ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem opening file from a server (https://www.excelbanter.com/excel-programming/387683-problem-opening-file-server.html)

Les Stout[_2_]

Problem opening file from a server
 
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

*** Sent via Developersdex http://www.developersdex.com ***

GS

Problem opening file from a server
 
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

Les Stout[_2_]

Problem opening file from a server
 
Hi Gary, i found my problem thanks.... My path is a string variable and
i left a "\" out... thanks again

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com