Excel reports "Error accessing file" when open an excel book w/ ma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel file w/ macros created in excel 2000. It does not have any
reference to other files and was working very well. Yesterday I tried to open
it on a new XP system w/ excel 2003. Excel 2003 reported error "Error
accessing file. Network connection may have been lost." And then Excel 2003
told me it was able to open the file with repairs: "Lost Visual Basic
project. Lost ActiveX controls". Although all the sheet data were remained,
the repairs had deleted all my macros.

I exited without saving the file - I can see that the last modified time of
the file was not changed. When I tried to open this file in Excel 2000 back
on my old system, I was able to open the file, execute the macros. However,
when I got into Visual Basic Editor, I am no longer to access my macro codes.
Dbl clicking on any module gave me error "Error accessing file. Network
connection may have been lost." I tried to export code and got the same
error. Also I could not save/save as the file, message was "Document not
saved."

Does anyone know how to fix the problem or at least, recover/export the
macro code so that I can re-build the book. Any help is appriciated.
 
Did you open the file directly from a floppy disk or other
removable media? If so, then you probably corrupted the file.
 
I have an excel file w/ macros created in excel 2000. It does not have any
reference to other files and was working very well. Yesterday I tried to open
it on a new XP system w/ excel 2003. Excel 2003 reported error "Error
accessing file. Network connection may have been lost." And then Excel 2003
told me it was able to open the file with repairs: "Lost Visual Basic
project. Lost ActiveX controls". Although all the sheet data were remained,
the repairs had deleted all my macros.

I had a similar error when attempting to open a workbook with Excel 2003. Even though I did not save the “repaired” file, when I attempted to open the same workbook across the LAN with Excel 2007 I had a similar “Error accessing file. Network connection may have been lost” error. My solution was simply to recover the workbook from last night’s backup. Since all I had done today was add new rows, I could simply copy these rows over from the corrupted workbook.
 
Back
Top