close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()