Excel VBA Hell
 

I've got some code and Excel crashes. Not everytime I run it. After
about three or four runs in a row excel doesn't even throw an error an
kicks me out.
Sometimes I get an "Automation Error; The server threw an exception",
but again it is not consistant. Should I be waiting for something to
close? I'm clueless. Thanks.


--
x86_man
------------------------------------------------------------------------
x86_man's Profile: http://www.excelforum.com/member.php...o&userid=34395
View this thread: http://www.excelforum.com/showthread...hreadid=541732

Excel VBA Hell
 

What does it do?

--
Tim Williams
Palo Alto, CA


"x86_man" wrote in message
...

I've got some code and Excel crashes. Not everytime I run it. After
about three or four runs in a row excel doesn't even throw an error an
kicks me out.
Sometimes I get an "Automation Error; The server threw an exception",
but again it is not consistant. Should I be waiting for something to
close? I'm clueless. Thanks.


--
x86_man
------------------------------------------------------------------------
x86_man's Profile: http://www.excelforum.com/member.php...o&userid=34395
View this thread: http://www.excelforum.com/showthread...hreadid=541732

Excel VBA Hell
 

I had a similar situation in a userform, I never did find where or how.
To recover, I had to rebuild the form, or load it from an earlier save
(I also exported the form after I created it, so I could also import it
too.)

If you have not saved a prior version, or have not exported the form,
you are pretty much out of luck. You may get lucky by closing
everything and rebooting the machine, loading the workbook, and then
exporting the modules so you can recover later.

Excel VBA Hell
 

Sounds like you are not closing your automation session.
Reboot your computer, run your code once, and terminate your application.
Using Task Manager, examine the Process TAB: Is there and entry Excel? If
there is, your automation session is still active; your code needs to
terminate the Excel session.