Excel XLSM file not running

[DannyDont]

I have an application that I am unable to bring up to full view. I have attempted to open the file without running macros but got the same results. The "hourglass " is on and stays on and never goes away until I select the Red X and close the app. I attempted to copy the file and open the copy. It copies fine but gives the same result. The file is 172 KB (Both original and Copy). It does open enough to see that I have several saved versions from the attempts I have made but I am unable to do anything with those as well. My concern is being able to access the VBA code to salvage the recent changes I have made. Any ideas? I do have a macro in the OnOpen in ThisWorkbook.

Any ideas?

 

[Michael M]

HAve you tried opening in Safe mode
Right-click the Start button (lower-left corner) in Windows, and click Run. Alternatively, you can press the Windows logo key and the R key on your keyboard. In the Run box, type one of these commands: For Excel: Type excel /safe, and click OK.
Otherwise try uploading the file to a hosting site like Dropbox, then post the link back here, and someone will probably have a look at it.

 

[Alex Blakenburg]

If Michael's suggestions don't work for you this might be worth a try.

Extracting VBA code from a closed, corrupt workbook

I have a large excel workbook that has become corrupt, and I am unable to open it (even in safe mode), without excel crashing or giving me an out of memory error. Is there a way to extract the VBA code from the workbook without actually opening it?

www.mrexcel.com

 

[DannyDont]

HAve you tried opening in Safe mode
Right-click the Start button (lower-left corner) in Windows, and click Run. Alternatively, you can press the Windows logo key and the R key on your keyboard. In the Run box, type one of these commands: For Excel: Type excel /safe, and click OK.
Otherwise try uploading the file to a hosting site like Dropbox, then post the link back here, and someone will probably have a look at it.

This got the job done. Thank you soooo much. I am back to being productive once again!

 

[Michael M]

Glad to help...