The way I do this type of thing is to save the filename and path in the
Registry. VB has a special area in the registry at
"HKEY_CURRENT_USER\Software\VB and VBA Program Settings" and the
SaveSetting method and GetSetting function will put a string into a key
at this location and read from it. SaveSetting is used something
like:

SaveSetting "Application title", "My Key Name", "My Data Value Name",
MyString

and GetSetting is used like

MyString = GetSetting "Application title", "My Key Name", "My Data
Value Name"

Hope this helps.

Seiscons