Forum Discussion
Entering Files via their Paths
How do I list all of the subfolders within the subfolders of a parent folder. Is there anyway to list them all by both file path and name (on two separate rows) without having to list them one by one...
o-mario64 Perhaps you can achieve what you need with Power Query (PQ). You can connect to all files in the Main Folder and all of its sub-folders .Normally you would then filter for similar files and combine them in some way, but that's not what you need. Just establishing the connection is enough. Excel/PQ will show a table with all files in and 'below' the Main folder with info on file type, creation date, full folder path and much more. Load that table back to Excel and use it to do your search from there.
The good thing is that you can Refresh the query and your Excel table will be updated as well.