Path and FullName in Excel VBA
The Path property in Excel VBA returns the complete, saved path to the workbook (Excel file). The FullName property in Excel VBA returns the complete, saved path, including the name of the workbook.
Download path-fullname.xlsm and add it to "C:\test\"
Place a command button on your worksheet and add the following code lines:
1. The following code line returns the complete path to path-fullname.xlsm.
Result:
2. The following code line returns the complete path, including the name of the active workbook.
Result:
For a practical example of the FullName property, see our example program Create a Footer Before Printing.
If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Data Analysis in Excel and Excel VBA.
