PC Review


Reply
Thread Tools Rate Thread

Path/File access error when using VBA editor

 
 
=?Utf-8?B?TGFycnk=?=
Guest
Posts: n/a
 
      21st May 2004
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

 
Reply With Quote
 
 
 
 
Mark E. Philpot
Guest
Posts: n/a
 
      27th May 2004
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
>
>.
>

 
Reply With Quote
 
 
 
 
=?Utf-8?B?TGFycnk=?=
Guest
Posts: n/a
 
      30th May 2004
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
 
Reply With Quote
 
New Member
Join Date: Mar 2009
Posts: 1
 
      20th Mar 2009
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]../images/icons/icon6.gif[/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
 
Reply With Quote
 
New Member
Join Date: Jul 2011
Posts: 1
 
      9th Jul 2011
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 - 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......
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access VBA - declared an Excel VBA reserved word and VBA/Access won't give it back! ultar6@gmail.com Microsoft Access 1 16th Jun 2007 05:11 AM
Deployment Using UserInterface Editor and Registry Editor A_PK Microsoft VB .NET 0 5th May 2005 09:13 AM
Is there an Add-In for the VBA editor that configures the editor . =?Utf-8?B?Um9uYW4=?= Microsoft Access VBA Modules 1 6th Jan 2005 02:32 PM
Is there an Add-In for the VBA editor that configures the editor . =?Utf-8?B?Um9uYW4=?= Microsoft Access VBA Modules 0 6th Jan 2005 11:03 AM
VBA - macro, security,vba editor Mike Microsoft Outlook VBA Programming 4 26th Jan 2004 06:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:36 PM.