Need only one DLL instance to run...
if two apps load the same DLL - LoadLibrary(...) - system will create to
different instance of the DLL...
Now, in my DLL i've a CList and i need it to be visible to all instance and
Is there a way!?
I need the dll to remain loaded till machine reboot!!! Is it possible!?
>if two apps load the same DLL - LoadLibrary(...) - system will create to
>different instance of the DLL...
>Now, in my DLL i've a CList and i need it to be visible to all instance and
>Is there a way!?
It'll be difficult to share a ...Excel combo box
Is there an easy way to maintain a date format from the original cell
through selection via a combo box?
Message posted from http://www.ExcelForum.com/
If you add the items yourself--instead of using listfillrange, then the combobox
from the control toolbox toolbar will keep the formatting:
Private Sub Worksheet_Activate()
Dim myCell As Range
.ListFillRange = ""
For Each myCell In Me.Range("a1:a14").Cells
or if you want...credentials to run this report are not stored
I'm getting this problem when I try and create a timed subscription.
Error: ...credentials to run this report are not stored.....
ok I created another folder under the same folder where I'm having this
loaded the report and I have no problem. I even moved the current folder
with that report in it. Creted another folder with the same name
and still the same problem with that named folder. With a different name for
the folder I have no problem???
I'm stuck here.. almost all post just talk about storing the credentials,
Already done and works...Word Mail Merge with Excel as data file
Why would a mail merge show only every other Excel row when merging with a
Microsoft Word form?
I am also cross-referening this to the Word forum.
Thanks in advance!
Sounds like perhaps you have TWO <<next record>> fields in your main
document for each, and you should only have one.
"HT" <firstname.lastname@example.org> wrote in message
> Word 2003
> Excel 2003
> Windows XP
> Why would a mail merge show only every othe...run time error 10-22-03
I am having a lot of trouble when I open up word I get
run time error 52 in VB. I have tried uninstalling word
and reinstalling it. WE have tried deleting the macro
but still to no avail can someone help me please?
...Excel Validation Drop Down Box
Is there any way to increase the size of the text in the
validation drop down box? If the sheet is zoomed to say
60% the text in the box is not readable.
No, but you may find this helpful:
In article <email@example.com>,
"Mike S." <firstname.lastname@example.org> wrote:
> Is there any way to increase the size of the text in the
> validation drop down box? If the sheet is zoomed to say
> 60% the text in the box is not readable.
...Repost: Error running Report in an Access 2003 db from Access 2007
Ok, clarification - ignore the code from my original post, some of the
reports do work. The ones that don't are reports that I have being filtered.
Here is the code from one of those buttons:
Private Sub Ok_Click()
On Error GoTo Ok_Click_Err
'using the customer sub form for customer state report to filter the
report, clicking ok will open report for selected state
Dim stDocName As String
Dim stLinkCriteria As String
If Not IsNull(Me.Search_Results) Then
stLinkCriteria = "[StateOrProvince] = """ & Me![Search Results] & """"...outlook 2000, email editor is word, no room for text
New user of Outlook 2000. Set WORD 2000 as email editor.
Open for New mail and get big gray space after first line
of tool bar and small space to enter text.
Each subsequent new mail, the text space disappears
completely as the gray space between the two tool bars
...System Error when opening Excel 2007
A client is receiving this error "system Error &H80004005(-2147467259)" in
excel 2007 when opening a new file or an exisiting file.
This error came up after visio 2003 was uninstalled and visio 2007 got
installed on his system.
This error can be a lot, and I looked a bit around where they say it might
be something with memory. But then I wonder why he never gave this error
before untill visio 2007 got installed.
Any help is welcome and I would be very thankfull to those who can help me
in this issue.
...Automatically run macro
My name is Mike and i have a question about microsoft excel macro's.
Attached is a copy of the excel sheet im working on. Below the excel
sheet is the macro I built. Some of the cells contain given values and
some cells are calculated from formulas. Cell (G4) is my given
value...it is related to cell (C32). The point is, I plug a value into
cell (C10) and it runs through the rest of the calcs in the other
cells and gives me a value to cell (C32). I built a macro that works
as a goal seek pretty much. The macro makes cell (C32) equal to cell
(G4) and gives me the value for cell (C10). I wan...New at this Excel VBA game and very perplexed
I am trying to export data from a Word form to a Excel spread sheet.
The Word form has three data fields. I want to export the form data to
a new row directly under existing rows in the spreadsheet (i.e., as
each new form is created I can run the macro and export the data to the
I have this code:
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim myWB As String
Dim oFF As FormField
Dim i As Long
myWB = "E:\My Documents\Word\Word Documents\Word Tips\Macros\Working
With Access And Excel\myExportBook1.xls&quo...Silly date/text question
Hi- is there an easy way to show dates/text with the day eg. July 17th
similar to Word 2k format eg July 17th . Currently cut/paste from Word 2k -
to get raised 'th' or 'rd' or 'nd' etc.
In custom format use
>Hi- is there an easy way to show dates/text with the day
eg. July 17th
>similar to Word 2k format eg July 17th . Currently
cut/paste from Word 2k -
>to get raised 'th' or 'rd' or 'nd' etc.
Are you looking for the th, rd, nd stuff or are ...Bug in CImageList::DrawIndirect in MFC Version 8
The size of the IMAGELISTDRAWPARAMS struct (defined in CommCtrl.h) depends
statically on the value of WINVER. However, CImageList::DrawIndirect
overrides the value of the cbSize member according to the runtime version of
Comctl32.dll. This messes up the display of images on XP and Vista, when
WINVER is set to 0x0500 - as required for applications that can also run on
A workaround is to set imdlp.cbSize to sizeof(IMAGELISTDRAWPARAMS), then
call AfxImageList_DrawIndirect(&imldp) instead.
> The size of the IMAGELISTDRAWPARAMS struct (defined in CommCtrl.h) depends...Hidden Column
Can anyone Help
I have a spreadsheet, and on my 3rd worksheet, the first column (A) wa
hidden, now I want to show that column, but it just isnt appearing.
I have tried, Format > Column > unhide as well as Row > Unhide,
Ive also tried Edit > Go To > A1 and it still doesnt appear.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Format > C...Excel Continuous Running Total
I posted a message earlier and have received a partial solution.
I want to keep track of how much stock prices go up or down with a running
total of how much they go up or down over several days until the direction
For example, if price go up 10 on Mon, 20 on Tues, 30 on Thurs and down 10
on Fri I want my running total column to show a positive number of 60 and
then a red number of 10 and continue adding the amount of the total of the
down days until the market shows an up day.
The formula I am now using total the first and second day but does not do a
running total count if t...tables created by Linking an Excel File
I have a linked access table created from an excel
spreadsheet. Then I used Table Analyze feature in access
to split this and the split created 3 seperate tables.
When the excel spreadsheet is changed the linked table
gets updated but split tables remains unchanged. Is there
a way these split tables to get updated automatically.
Thanks mates in advance for your help.
The table analyzer is designed for splitting a non-normalised table into
two or more new, normalised tables. This is a one-time process: the new
tables are entirely separate from the old one. T...display changing label caption on form as sub runs w/o screen flic
let's say i have this routine
label1.caption = "Starting ... "
label1.caption = "Getting there ... "
label1.caption = "Finished! ... "
on my form, i have label1 right in the middle
what happens is sometimes the message will change, and then sometimes it
wont, or it will show the first one, skip the second and jump to the third
etc etc etc
so it is inconsistent.
is there a way to make sure the label caption displays consistently, on
time, wh...Conditional Formatting in Excel
If D1 is empty then G1 should be white(clear)
if D1 has a number in it then G1 should be red
if a value, either a figure 0 or a currency value is entered in G1, which
owing to the previous two conditions, would be red, then G1 should change to
If anyone can explain how to acheive this I would be extremely grateful.
Ok, you have a few conditions:
Isblank(d1) means clear
Formatted as Currency Means “Blue”
Any value not formatted as Currency Means Red
I would insert a column to calculate this and format based on the resu...Create a custom footer for all Excel worksheets at one time...
I want to create a custom footer, just once, that could be applied to all
worksheets in an Excel workbook. Microsoft Word lets you do this, so why
not Microsoft Excel?
Try the code below:
Be sure to substitute the information for what you want.
Dim EachSheet As Worksheet
For Each EachSheet In ActiveWorkbook.Worksheets
' &F = File
' &A = Tab
' &D = Date
' &T = Time
' &P = Page
' &N = Pag...Money 2002 will not run
I had been using Money 2002 for approx. 3 yrs on my home pc (Dell Dim 2100,
XP Home Ed. w/SP2). Last year, it simply would not launch. No error message,
no splash screen, no app opening, no process listed in Task Manager. Just....
The only change that was made to the system since M2k2 last ran was
upgrading my a/v solution from Trend Micro PC-Cillin to TM Internet Security.
I have tried disabling every aspect of the Internet Security product, as well
as completely un-installing the app, and then attempting to run Money, but
the same thing (nothing) happens.
I was considerin...Powerpoint 2007 SP2 crashing when importing data
My user's are experiencing crashes when importing data from another program.
From Word or Excel, and it may be multiple issues. No error, the program just
locks up for 5-10 minutes, and then crashes.
Sometimes, office-kb975021-fullfile-x86-glb.exe fixes importing from Excel.
Other times, MicrosoftFixit50352.msi will fix importing from Word.
Other times, nothing will fix this.
From what I'm reading in some basic Google searches, this may have come up
with one of the updates included with SP2. Some suggestion even call for
removing SP2, either with a utility of ma...' in excel
when i type 'something in a cell. ' - as a single quote
it always display only something, without a '
anyone knows why?
does that ' mean anything?
it means the entry is in text form
charlie <email@example.com> wrote in message
> when i type 'something in a cell. ' - as a single quote
> it always display only something, without a '
> anyone knows why?
> does that ' mean anything?
The single apostrophe (') has long been a qualifer in spreadsheets to ...previewer for outlook 2007
hi there, recently i install outlook 2007 and notice that he can't preview
movie files such as windows media files. i searched microsoft oofice site.
get the built in supported types (only pictures, office documents) no movie
my question is " is there a 3rd party or any that can preview movie
really thanks for help..
That previewer is part of Windows so you should be running Windows Vista or
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Down...Excel Invoice #2
How do you transfer data, such as name, address, date, hours, charge per
hour, and total charge, from an Excel spreadsheet to an Excel invoice
without copying and pasting?
Hi, Ann. Try something like this:
Pay particular attention to the link in the 2nd bullet.
"Ann" <Ann@discussions.microsoft.com> wrote in message
> How do you transfer data, such as name, address, date, hours...Re: Workflow just wont run automatically, i have to run them manually
Yes, but i realized what i was doing wrong. I assumed [bad idea] that if i create a case and hit Save & Close the first time, taht the rule will run. In order for the rule to run automatically, it has to be Save, once it saves it, then Save & Close.
Thanks for your reply.
Did you check the workflow monitor to see if the rules get triggered
correctly and complete sucessfully ?
Have a nice day,
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://...