You must know something about the folder structure.

If you don't, just ask the user to locate the file.

If you do, make some guesses. If they fail, ask the user.

Possible guesses:
check c:\,
identify the drive in curdir
check the drive of the file with the code -- an add-in, I hope
check the drive of the open data file
check the drive of the system folder -- environ("systemroot")

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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