get workbook name only

Get full File Name (workbook and worksheet) and Path

In excel, you can get the current workbook name and it is absolute path using the CELL function. ¬†Just refer to the following formula: =CELL(“filename”,B1) Enter the above formula into any of cells in the current worksheet, then you will get the workbook name and its path, it is similar with the below format: path[book1.xlsx]sheet1… read more »