Application.DefaultFilePath Property (Excel)
Returns or sets the default path that Microsoft Excel uses when it opens files. Read/write String.
Syntax
expression .DefaultFilePath
expression A variable that represents an Application object.
Example
This example displays the current default file path.
MsgBox "The current default file path is " & _
Application.DefaultFilePath