Greg

Place this in a module in your Personal.xls outside of any procedures.

Public Const DefaultDir As String = _
"C:\Documents and Settings\GregR\My Documents\"

HTH
Paul

---------------------------------------------------------------------------------------------------------

Can I declare somewhere in VBA a default directory, such as:

Dim DefaultDir as String
Set DefaultDir = "C:\Documents and Settings\GregR\My Documents\"

and have it apply to all my modules in my personal.xls. TIA

Greg