Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Error xlEnt Excel Discussion (Misc queries) 2 May 15th 06 11:37 PM
RunTime Error (Automation Error) KD[_3_] Excel Programming 3 January 25th 05 01:56 PM
Automation Error, Unknown Error. Error value - 440 Neo[_2_] Excel Programming 0 May 29th 04 05:26 AM
Automation error in win 98 kehul Excel Programming 1 January 10th 04 07:47 PM
Unknown where is the problem on the Runtime error - Automation error wellie Excel Programming 1 July 10th 03 08:12 AM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"