Excel VBA Hell

[x86_man]

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.

[Tim Williams]

What does it do?

--
Tim Williams
Palo Alto, CA


"x86_man" <x86_man.27pu7y_1147473002.2771@excelforum-nospam.com> wrote in message
news:x86_man.27pu7y_1147473002.2771@excelforum-nospam.com...
>
> 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
>

[bgeier@fuse.net]

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.

[AA2e72E]

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.