%my document%\PackMaterials\

[ledzepe]

Hi everyone and again many thanks for any help.

In windows we can define environmental variable like %windir% to point to windows folders. Can we do the same for "My Document"?

I've made a save button macro so that this particular spreadsheet will be saved at C:\Documents and Settings\UserLoginName\My Documents\Stats. However the "UserLoginName" is not the same for all users and I need to distribute this spreadsheet.

Sub SaveWork()
Filename = Range("B2").Value
Workbooks.Open Filename:=%My Document% & "\stats\" & Filename & ".xls"
end sub

[bigwheel]

You could use Application.DefaultFilePath