ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automation Error (https://www.excelbanter.com/excel-programming/328702-automation-error.html)

Troy Street

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




All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com