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 »