Using VBA to access a file using the server path NOT a network drive letter

**CodeLiftSleep** · 07-31-2017, 10:57 AM

I have an issue where I need to be able to access a file on a server but it has to be using the server path rather than a mapped drive. The reason is that not all users might have that location mapped to the same drive.

How can I accomplish this in VBA using the server path?

**pbaldy** · 07-31-2017, 11:38 AM

Not sure what you mean. You can refer to the UNC path:

\\ServerName\ShareName\FileName

**CodeLiftSleep** · 07-31-2017, 01:03 PM

Yeah, I got it working...somehow there was an extra path that wasn't there on the drive when I mapped it...

Using VBA to access a file using the server path NOT a network drive letter

Thread Tools

Using VBA to access a file using the server path NOT a network drive letter

Similar Threads

Access DB not opening if specific drive letter not mapped

Linking a table using server name instead of mapped network drive

Link tables to server name, not mapped drive letter in Win 7

linking to a file on a mapped drive using combo boxes as variables for the file path

Output tables to an excel file on a network drive

Tags for this Thread

Posting Permissions