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
JFK wrote:
>
> 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
Similar Threads
