The following VBA is to name and save multiple files to a mapped network drive on a server. I have the code working when saving locally, however when saving to the mapped network drive, my files keep saving to a default directory rather than the specified location. I have read/write permissions for the network drive.
Thanks in advance...
Please Login or Register to view this content.
Last edited by wotsup; 03-13-2012 at 09:06 AM.
Try using the full UNC name of the folder
You don't need chdir.
This is all you need (provided cells A1:A5 contain valid Workbooknames, including extensions.
Please Login or Register to view this content.
Last edited by snb; 03-12-2012 at 06:52 AM.
I would go with kyle on this one
Please Login or Register to view this content.Please Login or Register to view this content.
Denis
Please always attach the sample workbook without sensitive information when asking for help
To add a module
Press Alt + F11 (this is the Visual Basic Environment)
Insert Menu, select Module
Past code there
Close Visual Basic Environment (X)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks