ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Path/File Access Error (https://www.excelbanter.com/excel-programming/399340-path-file-access-error.html)

[email protected]

Path/File Access Error
 
Hi there,
I've been working on an excel project, have just created 2 forms one
of which I've almost completed coding and the other one hasn't been
touched yet except for the interface design.

Everything works fine but all of a sudden I get a "Path/File access
error" when I try to save the project? I cant really predict when it
happens. usually after that if I try to export the forms I find one of
them doesn't export properly and gives a "System Error". Previously it
used to be the form I hadn't coded, recently its been the other one.
I then generally open my older backup copy, copy across all the code
and make the changes to the forms again and it works fine for a period
of time.

Any ideas on why this could be happening?! Am a bit clueless and its
making my life miserable!! Have already searched most of msdn and
Support and whatever I found doesn't seem to apply.

Any help would be greatly appreciated! Thanks!!


Leith Ross[_2_]

Path/File Access Error
 
On Oct 15, 8:17 am, wrote:
Hi there,
I've been working on an excel project, have just created 2 forms one
of which I've almost completed coding and the other one hasn't been
touched yet except for the interface design.

Everything works fine but all of a sudden I get a "Path/File access
error" when I try to save the project? I cant really predict when it
happens. usually after that if I try to export the forms I find one of
them doesn't export properly and gives a "System Error". Previously it
used to be the form I hadn't coded, recently its been the other one.
I then generally open my older backup copy, copy across all the code
and make the changes to the forms again and it works fine for a period
of time.

Any ideas on why this could be happening?! Am a bit clueless and its
making my life miserable!! Have already searched most of msdn and
Support and whatever I found doesn't seem to apply.

Any help would be greatly appreciated! Thanks!!


Hello Leoraj,

Do you ever change the directory path in code? Are you accessing a
network to retrieve a file? IF you have changed your file path to save
to network using a ChDir statement, this could be the cause. Check
your code carefully. You will probably find the error.

Sincerely,
Leith Ross



All times are GMT +1. The time now is 01:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com