Get A List Of File Names From Folders Sub Folders Using Power Query
Some time ago I wrote an Excel Tutorial about getting a list of file names from a folder in Excel. In that tutorial, I showed various ways to get the list of file names from a folder (using the FILE function and VBA). However, the limitation of that method is that it can only get the file names from a folder, and not from the sub-folders within the main folder....