Problem opening file from a server

  • Thread starter Thread starter Les Stout
  • Start date Start date
L

Les Stout

Hi all, we have various servers and everybody has them mapped to a
different letter, so i need to go to the server name so that no matter
who the user is, the path can be found. I however cannot get this to
work, i have tried \\zapd01\lcs\test.xls but it givs me an error ??

Les Stout
 
Hi Les,
This worked for me:

"\\servername\share\test.xls"

Are you wrapping the path in double quotes so it passes as a string?

HTH
Regards,
Garry
 
Hi Gary, i found my problem thanks.... My path is a string variable and
i left a "\" out... thanks again

Les Stout
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Map drive to open a file with code 4
Move File to new folder - Problem 1
Server name in Excel file path 4
Checking for open workbooks Repeat/Loop VBA code 1
Delete File in a folder 4
Path name problem with pivot data source 4
How to block all macro when a particular file is open 1
Opening a Workbook within VB 1

Back
Top