If they have several drives mapped, how would you know which is their file
drive.

I would add some code that prompts for the user to supply the letter, on
workbook open. Save the value somewhere, a hidden worksheet say, and then
you can check if a value is there, and not prompt again.

Also, think about an option to let them change it.

Either that, or assume nothing, and use GrtOpenFilename to let them pick the
file to open.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ben" wrote in message
...
In all my macros the file references assume that the file structure
resides
under the c drive. If I want to distribute these macros what technique do
I
need to use so that they can be used by other people who may be on a
network
and whose drive letter is unknown to me.
Thank you in advance