All my colleagues have mapped the s 1

[wmbb]

All my colleagues have mapped the same network drive but assigned to different drive letters.
Is there a way in VBA to detect the drive letter they've chosen to map the network drive called "measure_data"?
I want to use this code in a macro in WORD 2010.

 

[SkipVought]

Hi,

Counting on convention is not very reliable.

It is best to use the network server and share in your path without reference to the drive

\\server\share

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wmbb]

Hi Skip,

Good suggestion to use the network server and share.
I'll try that option.

Thnx for your quick response.

 

[wmbb]

Skip, this works and solves all my problems with different drive letters.
I'm going to this option in all my other macro's.
A star for you !

 

[SkipVought]

it is the way to go!

If your document is stored on a server, the easiest way to get the path is...

dim sPath as string

sPath = ThisDocument.Path

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}