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


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.
 
Ad

Advertisements

G

garfield-n-odie

Did you open the file directly from a floppy disk or other
removable media? If so, then you probably corrupted the file.
 
Ad

Advertisements

Joined
May 17, 2011
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top