VBA Coding Error︰Pressed "Reset" button and then crashes Excel（Automation error - Exception occured）

[smallxyz]

Hi all,

My Excel VBE behaves strangely recently.

Whenever I run VBA code in a module and encounter any Error, I will simply press the "RESET" button to re-inspect my code. Recently, after doing so, my Excel will hang for a moment and then prompt an alert window " Automation Error - Exception occured ". After clicking "OK" to continue. the whole Excel just crashes itself.

On the other hand, if the vba code runs smoothly without any error, my Excel just works perfectly as usual.

I have tested upon various sub-routines and notice that such crashing only occurs whenever I commit any coding error which is discovered and yellow-highlighted by VBE（but it shouldn't crash the whole Excel afterwards）. I have tried repair & also reinstall the Office but the issue still persists.

Clueless at the moment. Any one knows how to fix it?

Thanks in advance.

 

[sijpie]

I had a few automation errors as well recently. Check this website for some hints How Do You Fix an Automation Error in VBA? - VBA and VB.Net Tutorials, Education and Programming Services

If you did a reinstall of Office and it still occured, then I wonder what can cause this crashing behaviour.

 

[RoryA]

As you should well know by now:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:
VBA Error︰Pressed "Reset" button and then crashes Excel（Automation error - Exception occured）

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.