DefaultFilePath Property
Returns or sets the default path that Microsoft Excel uses when it opens files. Read/write String.
Example
This example displays the current default file path.
MsgBox "The current default file path is " & _
Application.DefaultFilePath