system error &H8000FFF (-2147418113

Hi All, I have just updated an xls file created in 2012 with a few changes and have saved it as an .xlm with Excel 2013. Now when I try to run the file I get the system error message that subsequently causes Excel to crash.

Can any one tell me how to fix this please.

Bunchil
LVL 1
BunchilAsked:
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.

byundtMechanical EngineerCommented:
I assume that you meant to say you are saving the file as .xlsm file format.

When I Googled for your error message (Excel error 2147418113), there were a number of disparate hits with fixes noted. Have you performed such a search and checked the leads out? Since you didn't post the file or describe what it contained, it is difficult to suggest anything specific.
BunchilAuthor Commented:
Hi byundit,

Thank you for your comment. I finally found an obscure error in the VBA code that caused the problem - I think I was too familiar with the code to see the error before.

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
BunchilAuthor Commented:
Hi byundit, thank you for your response. The VBA error I found was minor and stupid and so do not wish to take any credit for solving my problem. I had made some changes to the VBA code with a result that one section of code called for a subroutine that no longer existed in any of the VBA modules. This caused the system error that occurred when I tried to run the code after saving, closing and reopening the file.
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

byundtMechanical EngineerCommented:
Nonetheless, that is the answer to your question. Certainly not anything that I posted.

Normally, you get a different error message when one of the subs is missing. In the VBA Editor, does your Tools...Options...General dialog look like mine? If not, that may be why you are seeing a different error message.
Tools...Options...General dialog in VBA Editor
BunchilAuthor Commented:
Thank you byundit, my general dialog tab in the VBA editor appears exactly the same as the one you showed so I don't know why the error message I got.
byundtMechanical EngineerCommented:
Does the missing routine have the same name as a sub in a library that you have reference in your project (Tools...Options...References)?

I apologize for belaboring the point, but you should have gotten a runtime error and the debugger would have pointed you to the exact statement calling the sub that didn't exist. The fact that you didn't, makes this problem much more interesting.
BunchilAuthor Commented:
Hi byundt no it doesn't. The routine referenced undertook a regression analysis and the code for the analysis was in the routine referenced. I was cleaning up and simplifying (??) my code and renamed the routine that undertook the analysis and called the new routine directly from a command button.

Originally, the command button called a routine (now obsolete) which then called the routine (now renamed) that undertook the regression analysis
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.