Retreive Excel file names in cell and macro

[mr2bart]

Hi ! I am new here ! I can't find how to retreive Excel file name (of active excel file or other opened files) in a cell or in a macro. Help appreciated ! thanks!

 

[Momentman]

For the active excel workbook, you can use a formula like
=CELL("filename")

It will give you the full path and the filename like C:\Users\Momentum\Documents\ForMyBlog\[Dropdown_Reduction.xlsx]DropdownList, in which case, the filename is "Dropdown_Reduction.xlsx" and "DropdownList" is the sheet from which the formula was invoked.

if the file is not saved, the formula returns a blank

In VBA, you can use

?ThisWorkbook.Name

and that returns the name of the file directly

 

[mr2bart]

Perfect!

thanks!!!!