Macro-eating monster!

  • Thread starter Thread starter Jason Kossowan
  • Start date Start date
J

Jason Kossowan

After upgrading to Office XP, my existing Office 2000
Excel workbook which contained a series of macros in VBA
(the macros were actually the sole purpose for the
workbook) raised the following error on opening it:

"Error accessing file. Network connection may have been
lost."

It promptly "repaired" my workbook by removing the VB
project and ActiveX controls associated with it. The file
now contains none of the VBA code or functionality I'd
created.

VBA is installed and running from my local computer (I
went thru the control panel config).
 
I've read posts that say that sometimes xl2k will be more "considerate" and open
a file that xl2002 couldn't (and if you have xl2003, you may want to try that).

And if all these fail, you may want to try OpenOffice. Some people have posted
that it could save their code (as well as the data):

(http://www.openoffice.org, a 60-65 meg download or a CD)
 
Back
Top