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

Discussion in 'Microsoft Excel Crashes' started by Guest, Jul 5, 2005.

  1. Guest

    Guest 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

    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.
    Guest, Jul 5, 2005
    1. Advertisements

  2. Guest

    Guest Guest

    Anyone knows? Please!!!!!
    Guest, Jul 9, 2005
    1. Advertisements

  3. Did you open the file directly from a floppy disk or other
    removable media? If so, then you probably corrupted the file.
    garfield-n-odie, Jul 9, 2005
  4. garfield-n-odie, Jul 9, 2005
  5. Guest


    May 17, 2011
    Likes Received:
    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.
    DougF, May 17, 2011
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.