Printable View
gudday everyone
like my title says, i got a problem with this "error path/file acces error" always when i leave my project for sometime(shortest about 30sec) or when im in the middle of coding, then another problem occurs after that which makes me not save my progress and then excel errors afterwhich it restarts. though it reserves an autosave still its bugging me crazy..
what will i do?:help
thanks
We will need far more detail.
System type, version of Excel, what you are working on before the break/pause, is it always in the same file/workbook, etc. Remember we are not there working with you, so need to give us as much detail as possible.
aha ok. i thought its a common error.
here are the details
well im using xp xp3, ms excel 2007,
it was the same project where it happens always.
error occurs while im writing a long macro or when im testing a macro or just pause for break/surf net.
if theres still lacking, ill be glad to give more details.
-it happens again T_T
Check your options for valid backup folder. However, since it recovers, I doubt that is it. Another problem might be links that don't point to a valid location though this does not result in such a problem usually either.
yes i thought about that, if its the link that causes problems runtime error should occur and then it auto debugs showing the line that causes it, not this path/access error.Quote:
Originally Posted by Kenneth Hobs
im afraid that if i finish this project, this error may occur upon user usage..T_T
i want to understand why this error occurs and how to manage,kill it...
hoping for some answers...
Without seeing the workbook, it is near impossible to troubleshoot. Look for an OnTime() line of code or your sheets and workbook code objects.
sir kenneth,
ill email you a copy after i finished it, maybe in a week.
or do you want an unfinished one?
i have no OnTime() syntax on my code? or is it built in/on hide?
thanks
..........................
another thing
"error path/file access error" when occuring, hides the properties of the actual userform on design time / you cannot access the userform.
i guess im not the only one experiencing/had have this error.
i googled again and the same problems accounted on the other forums/sites, still theres no clear answer on none of them except maybe decreasing the chances upon moving the file to a local drive, or the drive where excel naturally saves the file(MY DOCUMENTS).
well if anyone had have this problem,hoping you post some solutions please...
thanks in advance
:hi: