if the file has been saved you can extract the path from the file name .I
paste this name into a couple of cells and manipulate it and use it in the
path,because different people save this file in different places.My main
macro calls this first


Sub printpath()
Dim myfull As String

myfull = ActiveWorkbook.FullName
Range("fullr").Formula = myfull
--
paul
remove nospam for email addy!



"seisman" wrote:

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