Tools -- Options -- General Tab -- Default file location:

The above is the menu option to change the default location. You have to
exit MS Excel then reopen it.

I don't see any of the code so if it is some VB code then probably use:

Sub DefaultLocation()
Dim strSaveAs As String
strSaveAs = Application.DefaultFilePath
MsgBox strSaveAs
End Sub

"Paul Dennis" wrote:

Is it possible to change this code to show which directory the SAVE.AS should
use asthe default?