VBA code running on startup of Word

[tempclerk]

Many months ago when I started working here, there was an annoying splash screen that came up every time I opened an Office Program. I got that to stop in Excel, but now when I am forced to use Word I get a Microsoft Visual Basic run-time automation error. How can I find out what code it is trying to run so I can get it to stop?

 

[Databaseguy]

From Word, shell out to the VBE (Visual Basic Enviroment) by hitting Alt + F11. From there, go to Debug/Complile project. Word will "hang" and highight any code that it can't compile. Put an apostrophe (') in front of every piece of offending code. This will "comment" it out and save it for later review by someone who knows VBA. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[tempclerk]

Tried your suggestion, and it did nothing. There is no apparent code to debug. Maybe should have mentioned that when I get the error message, the debug button is greyed out, and I can't get to the VBE without closing it. I assume this ends whatever VB is being run, which is why I need to find out what file or whatever the code is in so I can look at it.

 

[Databaseguy]

Sounds like a DLL, perhaps.

Go back in to the VBE,and check all of your references. Look for anything out of the ordinary and uncheck it. Or, look for references that say "missing" and un-check those.

Besides that, I'm stumped. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[tempclerk]

There are a couple hundred available references, only five of which are checked. None of them are marked missing (it would actually say that, right?). I have no idea what any of them are for. Any clues?

 

[Databaseguy]

I've got:
Visual Basic for Applications
Microsoft Word 8.0 Object Library
OLE Automation (Hmmmm)
Microsoft Forms 2.0 Object Library
Micrisoft Office 8.0 Object Library

Try unchecking the OLE Automation, if it is checked. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[dsi]

Do you have Adobe Acrobat installed? I have a problem with this every now and again. This addin is typically password protected and does not usually break on errors. But, on one of my systems, the application is not password protected. I changed my settings to break on all errors and found that there is an unhandled error in the addin. Haven't had time to figure out what exactly is going wrong.

 

[tempclerk]

I don't have Adobe Acrobat installed, but I was going to try unchecking OLE Automation and the error didn't occur when I opened Word! First time ever on this machine, but I tried it again, and again Word opened without the error. Maybe something I did yesterday did fix it?

Thanks for the suggestions!