Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path/file access error
If the file sits there without being accessed for a while, it gives a message
of "Path/file access error" in vbe. After I click "OK" several times (because the message keeps pumping up), another message appears, "An unexpected error occurred. AutoRecover has been disabled for this session of Excel." I click "OK" and the message is gone. But when I try to save the file, it says, "Document not saved." So, I have to close the file without saving, then it sends a typical error message, "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." and I have to choose "Send Error Report" or "Don't Send". Anyone knows the reasons and how to fix it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path/file access error
Any VBA involved, or is this basically an autorecover problem?
What is "the file" - a particular workbook or just a random file? Tim "Scott" wrote in message ... If the file sits there without being accessed for a while, it gives a message of "Path/file access error" in vbe. After I click "OK" several times (because the message keeps pumping up), another message appears, "An unexpected error occurred. AutoRecover has been disabled for this session of Excel." I click "OK" and the message is gone. But when I try to save the file, it says, "Document not saved." So, I have to close the file without saving, then it sends a typical error message, "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." and I have to choose "Send Error Report" or "Don't Send". Anyone knows the reasons and how to fix it? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path/file access error
I believe it is related to the vba of this file (or workbook) because the
error happens only to this particular file which has extensive vba codes. No such problem for any other Excel files. Thanks. "Tim Williams" wrote: Any VBA involved, or is this basically an autorecover problem? What is "the file" - a particular workbook or just a random file? Tim "Scott" wrote in message ... If the file sits there without being accessed for a while, it gives a message of "Path/file access error" in vbe. After I click "OK" several times (because the message keeps pumping up), another message appears, "An unexpected error occurred. AutoRecover has been disabled for this session of Excel." I click "OK" and the message is gone. But when I try to save the file, it says, "Document not saved." So, I have to close the file without saving, then it sends a typical error message, "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." and I have to choose "Send Error Report" or "Don't Send". Anyone knows the reasons and how to fix it? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path/file access error
Difficult to diagnose without seeing any code.
Maybe try disabling any error handling and see what line it fails on. Tim "Scott" wrote in message ... I believe it is related to the vba of this file (or workbook) because the error happens only to this particular file which has extensive vba codes. No such problem for any other Excel files. Thanks. "Tim Williams" wrote: Any VBA involved, or is this basically an autorecover problem? What is "the file" - a particular workbook or just a random file? Tim "Scott" wrote in message ... If the file sits there without being accessed for a while, it gives a message of "Path/file access error" in vbe. After I click "OK" several times (because the message keeps pumping up), another message appears, "An unexpected error occurred. AutoRecover has been disabled for this session of Excel." I click "OK" and the message is gone. But when I try to save the file, it says, "Document not saved." So, I have to close the file without saving, then it sends a typical error message, "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." and I have to choose "Send Error Report" or "Don't Send". Anyone knows the reasons and how to fix it? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path/file access error
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Path/File access error | Excel Discussion (Misc queries) | |||
Path/File access error | Excel Programming | |||
Run-time error 75 Path/File access error | Excel Programming | |||
Path/File access error (Error 75) using Name Statement | Excel Programming | |||
Path/File Access Error | Excel Programming |