Quote Originally Posted by Elroy View Post
A trick I've used very often is to use the Macro Recorder procedure in either Word or Excel, get it to do what I want, and then copy/paste/patch_up that code and put it into my VB6 program. It's a great way to get things going without spending hours in the MSDN sussing out all the VBA object model.
Ha ha, that brings back memories. I did just that to create my Normal.dotm macros many years ago.

I've transferred all my macros now into my VB6 programs and so far so good, they are working.

Now I hopefully won't have to worry about Microsoft with what seems to be constantly changing the goalposts with their macro security in Word.

Thanks for your help.