Retrieve the Workbook Name and File Path using VBA in Microsoft Excel

Enter the following code into VBA.

Function WorkbookPathName() As String
WorkbookPathName=ThisWorkbook.FullName
End Function

To use the this Custom Function just type =WorkbookPathName() into any cell.

Return to Excel Exchange homepage.