How can I get the file name to show up in a cell of the excel - Microsoft Community

You can use the CELL function to get the file and sheet names. CELL returns both the file name and sheet name in the format of "C:\Path[FileName.xlsx]SheetName". You can parse out the desired component from that string. So, to get the filename includi

answers.microsoft.com