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

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
AyansaneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Professor JMicrosoft Excel ExpertCommented:
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.
AyansaneAuthor 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
Professor JMicrosoft Excel ExpertCommented:
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?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nico _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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.