Hi Mark,
Try \\servername\shareddrivename\path\filename

--

John

johnf202 at hotmail dot com


"Mark Kubicki" wrote in message
...
i need to reference a file:
"E:\@ Timesheets\Job Nos for Timesheets.xls"
(the file is shared)

problem is that some of the office has the server as "E:", some as "F:",
and some as "E:\Server\"

and suggestions for determining and quickly extracting the file path with
i
could then concatenate to "@ Timesheets\Job Nos for Timesheets.xls",
creating a full path...

thought at this would give me direction, but alas:

Set fs = Application.FileSearch
With fs
.LookIn = "My Computer"
.Filename = "Job Nos for Timesheets.xls [Shared]"

thanks in advance,
mark