ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel crashes when attempting to open workbook...even with macros disabled (https://www.excelbanter.com/excel-programming/299313-excel-crashes-when-attempting-open-workbook-even-macros-disabled.html)

llowwelll[_10_]

Excel crashes when attempting to open workbook...even with macros disabled
 
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

--
Message posted from http://www.ExcelForum.com


Chip Pearson

Excel crashes when attempting to open workbook...even with macros disabled
 
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



"llowwelll " wrote in
message ...
Okay, I have a project that I have spent a TON of time on.

Just got it
to where I need it to be, and now, whammo, it won't open. I

get the
"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 tried
disabling macros and setting the Security to high and still the

same
result. I suspect that the workbook is corrupted somehow. How

can I
repair this file or at least recover the code from the VB

modules? I
have VB6 installed on my computer as well: is there a way to

import the
modules from this workbook into a VB6 project?


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com