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

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!)

Graham F wrote:

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

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" wrote:

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!)

Graham F wrote:

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

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



Graham F wrote:

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" wrote:

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!)

Graham F wrote:

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


--

Dave Peterson