Workbook.FullName Property (Excel)
Returns the name of the object, including its path on disk, as a string. Read-only String.
Syntax
expression .FullName
expression A variable that represents a Workbook object.
Example
This example displays the path and file name of the active workbook (assuming that the workbook has been saved).
MsgBox ActiveWorkbook.FullName