I am trying to move and rename an excel template file using a macro. My code works fine when it is moving the file locally on my C: drive. However, when I try to do it on a mapped network drive I get a Path/File access error. Here is the relevant code:
I tried it both ways that are commented out - both give me the error. I have permissions to read/write in all relevant folders. What am I missing here?Please Login or Register to view this content.
Bookmarks