Search:

Hi All,
Thanks all, particularly to Maud - you put me on the right track. It was the method of calculation, which is a bit bizarre, but well explained in http://support.microsoft.com/kb/214395 -...

Hi Maudibe,
I haven't used Worksheet_Calculate() event in any of the sheets. I'll try your other suggestion though it will take some time as there are quite a number of them.

Dougiew

Hi RetiredGeek (so am I)

I was afraid someone would ask for this but I will send something. I'll need to anonymise (is that a word?) the data but I'm sure I can, and I've got baby sitting duties...

Hi all,
This has been bugging me for quite some time and can't make sense of it. I have an excel 2000 spreadsheet with a number of sheets. One sheet holds demographic info on members of an...

Does the userform get closed after the first run, or is it just hidden?
Hi HansV,
I should have got back earlier - the problem was faulty coding, my own fault. I had a line in the wrong place. When...

Hi,
help anyone?
I'm using a button on a modeless form to create a mailmerge document (modeless so I can see what is happening). Works perfectly 1st time, but calling the form again, the form...

Thanks HansV,
I had all the stuff in the 2nd part - I think my problem was that my code to start the form was in the Forms module. Since your solution didn't say where to put it I thought I'd try...

Anyone know how to open/initialize/show an Excel userform from a Word userform?. I can start the Word userform, open, use and manipulate excel data but can't find how to start a userform created in...

Edited by HansV to replace very long URL with a link

Thanks Steve but while I was searching I cam across this in google groups see here
There were some answers using textheight and textwidth vb...

Hi Steve,
I have a very similar problem in that I need to truncate text (if necessary) to fit between two tab positions in a document. The tab positions are set using...

Edited by HansV to provide link to MSKB article by using <!t>[MSKB=326530]<!/t>
I had the same problem - and found <!mskb=326530>Microsoft Knowledge Base Article 326530<!/mskb> it seems to be the...

Hi to all Access Gurus - I'd appreciate comments/opinions/options on the following problem.
MS Access 2000 security of replicated database problem.

Working Scenario:-
Main DB on network server...

With Worksheets("Feb04").Range("B:B")
Set n = .Find("M", LookAt:=xlWhole, LookIn:=xlValues) ' do you need to look at whole or part???
If Not n Is Nothing Then ' Found...

I recently had a similar problem with a friend's PC and DID find something on knowledge base regarding "..... caused an error in mmsystem.dll" Can't remember the kb number but the fix was a missing...

PRINT field looks like it should be the correct way to do this but it doesn't seem to work with all codes and/or printer drivers. I found lots of other stuff on the web that explains why it doesn't...

Steve,
I have also had lots of problems with Excel mangling dates and found a variety of solutions over the years. One rule I make now is to set up a custom date of dd/mmm/yyyy to ensure I get the...

I want to send printer escape codes to a network printer from a Word macro but I'll probably want to port it to Excel and maybe others. Basic problem is to tell printer to switch duplex on/off but...

Hi Alex,
Me again. I don't see your ' end if' s, and I'm not sure about your select and paste ranges i.e. you have range("C7:BG11") which you are copying to a different sized range("C7:BG7????). ...

Alex,
Not sure I understand your question but I notice in your set pasterange = worksheetsSheets("macro calc").range("c7:bg7") - you have 'sheets' twice! that shouldn't affect copyrange though.

Richard - I have a suite of Word macros which control an Excel spreadsheet. One takes data from Excel and places it in Word; the other takes from Word and places in Excel. I've added it as a .txt...

Don't know if this will help - I use Office 2000 and have hit similar problems with macros not being available. Make sure the template is available if it isn't normal.dot - 'Tools' - Templates and...

Don't know if this will help but instead of using print screen, use 'my computer' or windows explorer. You can copy and paste information from the address box which wil pick up drive and folder...

When sending an Excel spreadsheet or a Word document using File

Thanks guys,
These have given me food for thought, however it's a pity there isn't a more robust system for document change control

Doug

Hi all,
I have problem in that I'm using version numbers to keep track of a particular document. The problem is I want to see the version number displayed in a footer and ideally a document variable...