Add-in Serious Error Message

[JFK]

I have a very large add-in that performs many complex tasks and calculations.
today I was adding code, and everything was going fine. I changed some code
that creates pull-down menus, saved the add-in *.xla file in the macro
editor, then closed Excel. When I reopened, I got a message "Excel
experienced a serious error the last time the add-in '****add-in name***' was
opened. Would you like to disable this add-in?....." I've tried many
things, but have not been able to reopen the add-in. How can I access the
code to try to correct the error?

 

[Dave Peterson]

Does this mean you answered yes to the reopen message?

Or does this mean you answered no and now can't find how to open the addin?

If it's the second, you can use (xl2003 menus):
Help|About MS Excel|Disabled items

If you still can't open the workbook, maybe you can start excel in safe mode:
Close excel
windows start button|Run
type:
Excel /safe
and hit enter

Then File|open the addin.

If that fails...

Maybe you could try opening (and saving as a new name on different pc's--or even
in different versions of excel).

Or maybe you could try openoffice:
http://www.openoffice.org, a 60-104 meg download or a CD

It's been known to save both data, formatting, and code from files that excel
couldn't. (I don't know if it opens xl2007 files.)

If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com