Path/File access error when using VBA editor

Discussion in 'Microsoft Excel Crashes' started by Guest, May 21, 2004.

  1. Guest

    Guest Guest

    I've been writing a VBA program for Excel for several months. I've noticed that when I have the visual basic editor open for long periods of time - sometimes while I'm continuously using it, and others just when sitting idle, I'll get an error message "Path/File access error". The error pop-up has the title "Microsoft Visual Basic". I will then not be able to save the file. Eventually it will also tell me that autosave is disabled amongst the flurry of errors. (Fortunately, I can copy/paste the vba from excel to Word and save it there - then restore the file later)

    The autosave directory and the directory that I'm editing the file from are both on a local drive, though on different partitions (C, D). IE., I don't think this is due to a remote file system that went away, which is a known problem. (I did install the registry change for that fix just-in-case, but it made no difference with Windows 2000 NOR windows XP.

    Also note: I originally was running excel 2002 on Windows 2000 and saw this problem. I have since switched to excel 2003 and windows XP and continue to see the same problem. The hardware is the same in both cases, though the drive, motherboard, and memory were replaced (for different reasons). The machine (IBM T30 laptop) is mostly stable otherwise. The OS(s) were installed from scratch onto a clean drive each time (from an image). Office XP was installed remotely, via an automated script, after Office 2002 was installed. I don't know if it did an upgrade vs. a remove and replace.

    Any ideas what's causing this? I'm currently running the latest service packs for XP. Not so sure regarding Office-XP. This was just installed by our IT department..

    thanks in advanc
    larr
     
    Guest, May 21, 2004
    #1
    1. Advertisements

  2. I have the same problem as I am only using 64 mb ram (will
    be upgrading soon!). The filepath seems to get lost. I
    close the editor then saveAS the excel file eg WAS
    myfile.xls now saveAs myfile2.xls. It is sometimes good to
    saveAs anyway for backup.
    Am using Excel2000 on windows98
    regards
    mark
    >-----Original Message-----
    >I've been writing a VBA program for Excel for several

    months. I've noticed that when I have the visual basic
    editor open for long periods of time - sometimes while I'm
    continuously using it, and others just when sitting idle,
    I'll get an error message "Path/File access error". The
    error pop-up has the title "Microsoft Visual Basic". I
    will then not be able to save the file. Eventually it will
    also tell me that autosave is disabled amongst the flurry
    of errors. (Fortunately, I can copy/paste the vba from
    excel to Word and save it there - then restore the file
    later).
    >
    >The autosave directory and the directory that I'm editing

    the file from are both on a local drive, though on
    different partitions (C, D). IE., I don't think this is
    due to a remote file system that went away, which is a
    known problem. (I did install the registry change for that
    fix just-in-case, but it made no difference with Windows
    2000 NOR windows XP.
    >
    >Also note: I originally was running excel 2002 on Windows

    2000 and saw this problem. I have since switched to excel
    2003 and windows XP and continue to see the same problem.
    The hardware is the same in both cases, though the drive,
    motherboard, and memory were replaced (for different
    reasons). The machine (IBM T30 laptop) is mostly stable
    otherwise. The OS(s) were installed from scratch onto a
    clean drive each time (from an image). Office XP was
    installed remotely, via an automated script, after Office
    2002 was installed. I don't know if it did an upgrade vs.
    a remove and replace.
    >
    >Any ideas what's causing this? I'm currently running the

    latest service packs for XP. Not so sure regarding Office-
    XP. This was just installed by our IT department...
    >
    >thanks in advance
    >larry
    >
    >.
    >
     
    Mark E. Philpot, May 27, 2004
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Hi Mark
    thanks for the suggestion. Unfortunately, the problem that I'm having is slightly different. In my case, when the error occurs, it won't save at all. I can't even do a save as - it failes and gives a message "file not saved". This problem is as if excel has disconnected from the file system completely - at least for purposes of saving files..

    thanks for the suggestions though
    larry
     
    Guest, May 30, 2004
    #3
  4. Guest

    garouda

    Joined:
    Mar 20, 2009
    Messages:
    1
    Likes Received:
    0
    Hello World! (from the first programming lesson a couple of years ago)




    As new bee on this site, a short introduction. I live in Thailand where I work as Headmaster of a college. I use VBA quite a lot since it is implemented in Excel (Excel 5?) but I am not a professional at all.

    I have exactly the same problem, after a while if I try to view a user form, I get the message File Path Error, if I try then to save my workbook, excel crashes. [​IMG]

    I get the impression that Excel "looses" the path to its folder...


    Fortunately (?) I am using Excel 2007 and the auto recovery feature works quite well.

    Anyway, does someone have the explanation or some hints?

    Thanks and Cheers
     
    garouda, Mar 20, 2009
    #4
  5. Guest

    CopperKennedy

    Joined:
    Jul 9, 2011
    Messages:
    1
    Likes Received:
    0
    This is an oldish thread, but having experienced a similar problem - receiving a Path/File Access Error and being unable to save my work on several occasions - I accidentally 'fixed' the problem in the following way:

    I opened a new workbook in the same instance of excel.

    I added enough sheets to the new book to equal the number of worksheets in the error causing book + 1 (i.e. I had 8 sheets in the old book so I created 9)

    I deleted the first eight sheets in the new book, leaving me with just "Sheet9"

    I copied the old sheets across using the sheets 'Move or Copy' function and pasted them before "Sheet9" (in this way all the sheets retained their sheet numbering so the vba code referencing the sheets was not upset).

    I copied the forms over into the new book.

    (I had hoped that I could just move all off this back after saving the new book and closing excel, losing my previous work), however, after going through all of this, all of a sudden the error disappeared and I could save my work:thumb: - nothing lost!!

    Not sure which element in that process sorted things out, but I thought it was worth posting after spending an hour looking for an answer online......
     
    CopperKennedy, Jul 9, 2011
    #5
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guy Damico

    Crash using the Formula Editor

    Guy Damico, Apr 8, 2004, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    215
    Guy Damico
    Apr 8, 2004
  2. Sean via OfficeKB.com

    access rights to be able to run VB editor in Excel

    Sean via OfficeKB.com, Oct 31, 2006, in forum: Microsoft Excel Crashes
    Replies:
    1
    Views:
    165
    Simon Murphy
    Nov 1, 2006
  3. RWN

    Scroll wheel keeps switching to VBA editor

    RWN, May 18, 2007, in forum: Microsoft Excel Crashes
    Replies:
    2
    Views:
    214
  4. aseeger

    Run Time Error '75' Path/File Access error

    aseeger, Apr 7, 2009, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    589
    aseeger
    Apr 7, 2009
  5. Rod R
    Replies:
    0
    Views:
    611
    Rod R
    Apr 13, 2010
Loading...

Share This Page