Excel crashes when attempting to open workbook...even with macros disabled

L

llowwelll

Okay, I have a project that I have spent a TON of time on. Just got i
to where I need it to be, and now, whammo, it won't open. I get th
"Microsoft Excel has encountered an error and needs to close" message.
There is quite a bit of VB code in this project. However, I have trie
disabling macros and setting the Security to high and still the sam
result. I suspect that the workbook is corrupted somehow. How can
repair this file or at least recover the code from the VB modules?
have VB6 installed on my computer as well: is there a way to import th
modules from this workbook into a VB6 project
 
C

Chip Pearson

Try opening Excel in Safe mode. From the Windows Start menu,
choose Run, and enter

Excel.exe /s

If you can open the workbook in save mode, export all the VBA
code to text files and import it in to another file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top