Excel causing exception error upon opening the document

[dougmcc1]

Hi,

I have a workbook with a macro and when I try to open it I get a
application error message that says Excel.exe exception acces
violation. The document closes after I get the error message. The erro
message pops up before I have time to do anything although I did tr
disabling macros and using CTRL + Break but to no avail.

How can I retrieve the data from the spreadsheet and the code from th
macro?

Any help is greatly appreciated. Thanks

 

[Dave Peterson]

Chip Pearson has some notes to help diagnose startup problems at:
http://www.cpearson.com/excel/StartupErrors.htm

You might be able to recover more by using another program--both xl2002+ and
OpenOffice have better reputations for opening files that earlier versions of
excel couldn't.

(http://www.openoffice.org, a 60-65 meg download or a CD)

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