Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation Error
Hi,
I have some straight-up VB experience, but when it comes to VBA I am a little shaky on a few concepts. I am hoping someone here can help me with a problem I have run into. I recently wrote a macro that consists of a few user forms. On most machines, it runs exactly as intended. On two machines, I get error messages "Automation Error. An unspecified error has occurred.". I took out my error trapping hoping to catch the offending code line, but it appears to be happening before any code is executing. Thinking perhaps it has something to do with control references (I added the MS dialog control, and MS Picture combo during design), I tried to add these components from the users computer, but cannot save the workbook afterwards. I assume since these controls show up on the list of available references/controls, that they are properly registered? Is there a way I must reference them in code? Or am I completely barking up the wrong tree? At this point, I am not sure what is going on... can anyone offer some suggestions? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automation Error | Excel Discussion (Misc queries) | |||
RunTime Error (Automation Error) | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Automation error in win 98 | Excel Programming | |||
Unknown where is the problem on the Runtime error - Automation error | Excel Programming |