Get full File Name (workbook and worksheet) and Path
December 19, 2017
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 »