system error &H8000FFF (-2147418113

Bunchil
Bunchil used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
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.
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.

Author

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.
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
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

Author

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 Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
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.

Author

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

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