Retrieve the Workbook Name using VBA in Microsoft Excel

Enter the following code into VBA.

Function WorkbookName() As String
WorkbookName=ThisWorkbook.Name
End Function

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

Return to Excel Exchange homepage.