File Not Found using network paths.

I am trying to rename a file using a network path rather than a mapped drive letter due to the fact that different people use different drive letters for the specific location.

When I use the "name filefrom fileto" approach I am getting a "File not found" error. Again, things work fine when I use a drive letter, but that's no longer practical.

I can do a test (dir) on the folder where the file is located and I get a positive result, meaning the code "finds" the FOLDER. But, when I do the same test on the FILE itself (using the whole UNC file path) the code cannot find the file.

Any ideas?

Thanks.

can you provide your code?

i'm guessing that the file path has an error in it it should be in the following format:
\\MAMMOTH\AcctDocs\filename.extention

Absolutely, only posting the code is tricky because the folder and filename makeups are in the form of variables.

My first thought was that of a typo as well, but I've gone over the strings about a hundred times now.

The path to the file is this:
"\\grsbncsxr03\shr_Eastern_Eastern_GRSB_Fso\Eastern FCCMT\CMT Standard Documents\_Contract Award Folders\_Buyer Folders\Test 4\Contract Award Data.xls"

This is part of the larger macro code:

Please Login or Register  to view this content.

That's just a space between the buyer name and the "Contract Award..." . It's intentional.

Well, it turns out that the file name, path and everything else was fine.

The firewall between me and this particular server was causing the "name" statement to time out, if I'm saying that correctly anyway. I was able to test the code on the "other side" of the firewalll this morning and it runs fine. No errors.

Still have to figure out the firewall problem, but at least it's not my code.

Thanks all.

Cheers.