My code used to work.
Now it creates a new folder but no longer recognizes the new file path. The result is an error message. ("run Time error 75" path/file acces error)
I am have been unable to troubleshoot what I did.
I rechecked the fokder file path already.
only thing I can think of is that I inadvertantly erased something.
Please Login or Register to view this content.
Can some one please help troubleshoot my code.
Hello IBM,
If your are receiving an error when running the code, please tell us the error number and where in the code the error occurs.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you for your replyOriginally Posted by Leith Ross
My original post shows the error code.
The error occurs after the folder is created and set in the designated file path.
That is when the error code showed.
Hello IBM,
There are a couple of reasons this could happening: Illegal characters in the folder name or Access rights violation.
I'm not sure what illegal characters are? Perhaps some examples may help.
What are the access rights violations? I am not certain what you mean.
Hello TBM,
Windows forbidden ASCII characters for files and folders...
< (less than)
> (greater than)
: (colon - sometimes works, but is actually NTFS Alternate Data Streams)
" (double quote)
/ (forward slash)
\ (backslash)
| (vertical bar or pipe)
? (question mark)
* (asterisk)
0-31 (ASCII control characters)
There are reserved system names you cannot use as well. Here is brief list...
CON, PRN, AUX, NUL
COM1, COM2, COM3, COM4, COM5, COM6, COM7, COM8, COM9
LPT1, LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, LPT9
Ok
Back to my original question.
Is there a way for someone to troubleshoot this code.
It worked for 6 months. Now it does not.
Hello TBM,
The first step in troubleshooting is check what has most recently changed.
Did your system get recently updated?
Did DropBox update its software. recently?
Have any changes been made to code or applications that call it?
Posting your workbook would the best way to troubleshooting any problems in the code.
Is there a way for someone to test the code on a new work book?
Mine has to much info to put online.
the code succesfully creates a new folder in the location it is supposed to.
when it creates the file, off of the following code,
I am now getting a new error message.Please Login or Register to view this content.
"Run-time error '1004'
microsoft excel cannot acces the file
'c:\FILEPATH\90F9C300'. There are several possible reasons
.the fike name or path does not exist
. the file is being used by another program.
I am not sure that it is the code as I usea similar one and it works fine.
Any ideas?
Again any help would be appreciated.
I attempted to change the file path location by sending it to my desktop. i Recieved the same message.
I solved the issue by resaving the book manually with a new name and then breaking all links.
I am still not certain why it failed, but it is fixed now.
Thank you for all your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks