VBA Project Lost

[Guest]

I am running Excel 2000, and from time to time I get an error message saying
that Excel has lost the VBA project, after recovery the workbook has no VBA
code in it! Is there anything that can be done to prevent this? Or is it a
situation that is unavoidable. Many thanks for any help. Graham

 

[Dave Peterson]

Lots of people have praised OpenOffice.org for saving their data and code.
http://www.openoffice.org, a 60-104 meg download or a CD

There are commercial recovery services. I've never used it, but you might want
to check into:
http://www.officerecovery.com

And sometimes newer versions of excel can open files that older versions can't.
(And sometimes just different versions may work, too!)

 

[Guest]

Hi Dave, Thanks for the prompt reply, the file can be recovered, as you said,
by XL 2003, but the VBA has gone completely, all modules etc are empty! I
have backups of course. But that is not really the point, I am supprised that
xl can be so flakey on a regular basis. Is this "normal" whatever normal is!!
Many thanks, Graham F

 

[Dave Peterson]

I think that this is very unusual behavior--but it still happens.