AHHHH!! Excel file not opening

[andrew299]

Please Help, I have written a macro in excel and saved as normal etc before closing down. Now when I want to open my file I get a white screen in excel and then it closes and I cant do anything. I dont care about the content of the file except for my program. Is there any way I can get the macro out of this file?

It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)

 

[aznluvsmc]

Are you able to open any other file in Excel? Try running Detect and Repair from the Help menu within one of the Office programs. This will repair any errors in the Office suite. Hopefully it'll fix your problem.

Steven S.
MCSA
A+, Network+, Server+, i-Net+

 

[longhair]

andrew299,
could also be the code you put in the macro. try opening the file and hitting the 'esc' key to break into the macro.
hth

regards,
longhair

 

[Persmd]

Try holding down the Shift key while you start Excel. That should prevent the macro from executing on startu.

 

[Persmd]

I meant hold down the shift key, while you open the file....

 

[andrew299]

No luck with ny of those. Thank you all for your help, I have rewritten all of my code now but it would still be useful to find out a way of opening a file like this.
Thanks again.
Andrew

It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)