Hi guys,
I currently have the following code:
This works fine in that it takes the value in A1, uses it as a file name and saves it to the folder on the S drive.Please Login or Register to view this content.
However, I have a problem. The S drive is a network drive and not everyone in the company has it mapped to the letter S. Therefore I think I want to use some code like this at the start so that it doesn't matter what letter people have the drive mapped to:
ChDrive "\\network1\shared$\"
ChDir \\network1\shared$\Folder\
I can't get it to work though! Does Chdrive have to just be a letter? If so, how on earth can I get this to work?
I hope that's clear and many thanks for any help at all!!
Cheers,
David.
Bookmarks