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.
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:
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:
gt;
gt; I am running Excel 2000, and from time to time I get an error message saying
gt; that Excel has lost the VBA project, after recovery the workbook has no VBA
gt; code in it! Is there anything that can be done to prevent this? Or is it a
gt; 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 quot;normalquot; whatever normal is!!
Many thanks, Graham F
quot;Dave Petersonquot; wrote:
gt; Lots of people have praised OpenOffice.org for saving their data and code.
gt; www.openoffice.org, a 60-104 meg download or a CD
gt;
gt; There are commercial recovery services. I've never used it, but you might want
gt; to check into:
gt; www.officerecovery.com
gt;
gt; And sometimes newer versions of excel can open files that older versions can't.
gt; (And sometimes just different versions may work, too!)
gt;
gt; Graham F wrote:
gt; gt;
gt; gt; I am running Excel 2000, and from time to time I get an error message saying
gt; gt; that Excel has lost the VBA project, after recovery the workbook has no VBA
gt; gt; code in it! Is there anything that can be done to prevent this? Or is it a
gt; gt; situation that is unavoidable. Many thanks for any help. Graham
gt;
gt; --
gt;
gt; Dave Peterson
gt;
I think that this is very unusual behavior--but it still happens.
Graham F wrote:
gt;
gt; Hi Dave, Thanks for the prompt reply, the file can be recovered, as you said,
gt; by XL 2003, but the VBA has gone completely, all modules etc are empty! I
gt; have backups of course. But that is not really the point, I am supprised that
gt; xl can be so flakey on a regular basis. Is this quot;normalquot; whatever normal is!!
gt; Many thanks, Graham F
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Lots of people have praised OpenOffice.org for saving their data and code.
gt; gt; www.openoffice.org, a 60-104 meg download or a CD
gt; gt;
gt; gt; There are commercial recovery services. I've never used it, but you might want
gt; gt; to check into:
gt; gt; www.officerecovery.com
gt; gt;
gt; gt; And sometimes newer versions of excel can open files that older versions can't.
gt; gt; (And sometimes just different versions may work, too!)
gt; gt;
gt; gt; Graham F wrote:
gt; gt; gt;
gt; gt; gt; I am running Excel 2000, and from time to time I get an error message saying
gt; gt; gt; that Excel has lost the VBA project, after recovery the workbook has no VBA
gt; gt; gt; code in it! Is there anything that can be done to prevent this? Or is it a
gt; gt; gt; situation that is unavoidable. Many thanks for any help. Graham
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;
--
Dave Peterson
- May 27 Tue 2008 20:44
VBA Project Lost
close
全站熱搜
留言列表
發表留言