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

  2. Guest

    Guest Guest

    Anyone knows? Please!!!!!
     
    Guest, Jul 9, 2005
    #2
    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
    #3
  4. garfield-n-odie, Jul 9, 2005
    #4
  5. Guest

    DougF

    Joined:
    May 17, 2011
    Likes Received:
    0
    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
    #5
    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.