While this formula does not work in the worksheet cells, it still works in named ranges We will use this fact to get the list of file names from a specified folder Now, suppose you have a folder with the name – 'Test Folder' on the desktop, and you want to get a list of file names for all the files in this folder Here are the steps that will give you the file names from this folderClick to expand In B1 use = CELL("filename",A1) with some text manipulation formulas wrapped around it to extract the sheet name from the value the CELL function returns AlphaFrog MrExcel MVP Joined Messages 16,430 Aug 1,Excel, VBA, SQL – Developer / Report Analyst ;
Get Sheet Name From Excel Page 2 Alteryx Community
