I have people that access shared files on a server named "SANSRV07".
I have macros & links that uses the Path s:shared..............
However personnel outside the city have SANSRV07 map as a drive other than S:
I don't see how I can changed my macros/links to read sansrv07:shared... in my EXCEL and ACCESS files, so that everyone can use the same file(s).
I tried using the path:
"\sansrv07shared........" instead
of:
"s:shared......"
but VBA givesme an error when I use \sansrv07 insted of the mapped drive S:
Does any one have any suggestions?
Thank you,
- Keith
I have macros & links that uses the Path s:shared..............
However personnel outside the city have SANSRV07 map as a drive other than S:
I don't see how I can changed my macros/links to read sansrv07:shared... in my EXCEL and ACCESS files, so that everyone can use the same file(s).
I tried using the path:
"\sansrv07shared........" instead
of:
"s:shared......"
but VBA givesme an error when I use \sansrv07 insted of the mapped drive S:
Does any one have any suggestions?
Thank you,
- Keith