Recent content by SnakeCharmer

Hi Bill I've resolved the problem and heart-felt apologies are in order! In the Macro that calls the code I had mistakenly opened the module instead of just running the code. Thanks for all your help though - the close windows procedure is great and I'm bound to use it somewhere else. Jake

Hi Bill Thanks, that works, unfortunately a bit too well! It closes the VB window, but also closes the DB itself...? Cheers Jake

Hi Bill The task is listed as: **** Microsoft Visual Basic - Primary Pool [break] - [Primary Pack Letter (Code)] **** Where Primary Pool = db name and Primary Pack Letter = the mailmerge module Thanks Jake

Thats great, thanks Bill! (Sorry I should really have noticed myself) Just one other thing - I also need to close the VB window thats brought up, but I'm not sure how to refer to it. I tried using acDefault as it's the active window after Word closes, but I couldn't get it to work. (Sorry if...

Thanks Bill Unfortunately I get a **run-time error 438: Object doesn't support this property or method** when I run the module with the extra lines. Any ideas!? Jake

I have the following module to run off a mailmerge and was wondering how I could modify it to close (without saving) the original letter thats opened and the merged doc thats created. Thanks! Function MergeNewPacks() Dim objWord As Word.Document Set objWord =...

Fantastic! Thanks very much

I have the following code to change all cells on a worksheet to uppercase: ****** Sub MakeUppercase() For Each cell In ActiveSheet.UsedRange If cell.HasFormula = False Then cell.Value = UCase(cell.Value) End If Next cell End Sub ****** I can change the UCase to an LCase to...

Hello How do I automatically insert the current date in a field when another box is ticked? Thanks Jake