Archive of Mr Excel Message Board

Back to Errors in Excel archive index
Back to archive home

ARGH!! What have i done! I've broken Excel!

Posted by Dave on January 17, 2002 8:03 AM

Help!
i tried to delete one of my subs in one of my modules (by selecting it and pressing backspace) and excel crashed... i then tried to delete it bit by bit and each time i got to a particular point (different each time) "fatal exception in vba332 somthing or another" occured.....

now the sub is finally gone but, every time i start excel i get:

56E4C000 file format not supported
E7D8C000 file format not supported

and several more in the same vein!

What have i done and how do i undo it!

Thanks for any help,

Dave (looking more than slighly worried)

More details

Posted by Dave on January 17, 2002 8:05 AM

Sorry, the error reads "XXXX file format is not valid"....

Don't Worry. Fixed it...

Posted by Dave on January 17, 2002 8:26 AM

For anyone who is interested (in case you get the same problem or whatever) there were random files being created in the office\xlstart directory. once those had been deleted everything rreturned to normal!

Sorry about the multiple posts....

Dave *hangs head and wanders off*

Re: More details

Posted by Joe Was on January 17, 2002 8:28 AM

What did the macro do?
By chance did it link with other files, save, load or close files?

It sounds like it may have run a portion of a macro which due to the bit by bit deletions became destructive?

Did you try a re-boot?

If you re-install you will not loose your other files, but it seems like your current file will need to be deleted. You may need to delete the corrupted file before you reinstall?

Try deleting the corrupted file, re-boot then see if Excel will reload, it may?

If not Re-install Excel. JSW

Good, thought deleting files would help. nt

Posted by Joe Was on January 17, 2002 8:30 AM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.