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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.