Which particular drive letter?

If it is the one to which they save their files by default, use:
Left(application.defaultfilepath,3)

If it is where Excel is installed, use:
Left(application.path,3)


"VBAfunkymonk" wrote:

hi i am tryting to save a file on a sharded drive how ever as other people
will be using it and they have different dirve letters is there a way I can
find what their dirve letter is and then specify what the drive letter is in
my code??