Automation Error



I am having this problem with this file I have been
working on. I am not sure if it is a reference problem
or what. When I start up excel, everything seems to be
fine. I created a button on a worksheet to start my
macro with brings up a userform and then I can do
different functions or whatnot from that point. But
sometimes when I click that button after I just opened up
the file, excel will crash and say Automation Error and
then shutdown and reopen. At other times, Excel will say
that there is a type mismatch, but when I go to debug,
excel crashes. However, if I hit end at that point, and
go to the reference box in VBE, I will switch the
positions of the OLE Automation and the Windows Common
Controls. Does anyone know what might be going on



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation Error 0
Automation Error 0
Automation Error 0
automation error 0
Automation Error 0
Automation error 1
Automation Error and Crash 0
Automation Error 440 1