The eternal stench of Word VBA

September 6, 2006

I'm currently doing some project work with Microsoft Word 2003 using VBA to populate a Document template. It uses an Access database to dynamically load certain tabs in the form etc.

I had a problem yesterday which I think I've resolved thanks to the microsoft.public.word.vba.general group. You can actually compile your VBA code by gettnig into the editor (ALT-F11) and then selecting Debug | Compile ... from the menu bar.

This seemed to get rid of the error ("Microsoft Word has
encountered a problem and needs to close") when opening an instance of the template.

You don't appreciate Visual Studio 2005 and .Net 2.0 until you go back and see how terrible VBA work was back the past! I'm hopeful that I will never have to touch this stuff again once I move into Contracting and leave the stench of the past behind me!

diigo itdeliciousdiggfacebookreddit

Comments

blog comments powered by Disqus