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

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

瀏覽:1062
日期:2025-05-03
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...看更多