Excel Displaying Error Message !! << Automation Error >> and << Catastrophic Failure >>

Ayansane
Ayansane used Ask the Experts™
on
Please Help...

Excel gives me the following error:

                     <<  AUTOMATION ERROR
                                   CATASTROPHIC FAILURE >>

I had one file open..and this occurs when I try to open another Excel file i often use.  Both files have VB used for basic functions (printing, reclassification, etc).

Thank You
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
Propably a reference that is broken/missing
Open the VBA-editor by pressing ALT f11 then Choose Tools | References... and uncheck any reference named ISMISSING.

Author

Commented:
Thanks, I've open the VBA Editor, but did not see any "IsMissing" name..

The error froze the computer and and the Excel application.  I had to shutdown and reboot...  but Excel kept locking up.

Any suggestions..?   Thx
Microsoft Excel Expert
Top Expert 2014
Commented:
Open excel is safe mode and then disable macros then open the file which causes the freeze , press alt f11 then click on Thisworkbook object and see what code is there?

Commented:
This error happened to me as well and I found the following solution:

Symptoms:
- I used Excel 2013
- I had created user defined functions within Excel which used a string as input parameter:

Function ProjectTags(sAcDump As String) As String

- The functions worked just fine before saving the file.
- After closing and re-opening the file Excel showed the automation error and the 'catastrophic failure' message. The Macro Editor jumped to my custom functions.

Solution:
- When opening, Excel didn't accept the string-parameter in the custom function. After changing this reference to a range-parameter the error was solved:

Function ProjectTags(AcDump As Range) As String

I came to this solution after reading the bottom-reply on this page (https://social.technet.microsoft.com/Forums/office/en-US/341479ae-903a-423e-9a51-c3456ae7ad13/automation-error-catastrophic-failure?forum=excel):

--------------------------
'My head was about to explode, I had the same problem in Excel 2013, my macro worked fine for a few weeks before starting to get the "catastrophic" error. The function I made had a variant parameter for the range of cells and was producing the "catastrophic automation failure" when opening the file, I could still stop the macro and after that the file worked fine which made things even weirder.

After changing the parameters from variant to range it all works fine!

Thank you for posting the solution!.

Angel'
--------------------------

Hope this helps,

Reg, Nico

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial