Fast Tip Friday – Get List of All Files in a Folder Using Excel Macro
In a previous FTF video entitled Using DOS to Create File Listing, I demonstrated how to use DOS commands to create a file listing. This fast tip demonstrates how to use an Excel VBA macro to generate a file listing in Excel.
In other FTF videos I have demonstrated how to use Excel VBA macros to (1) generate a folder listing in Excel (instead of a file listing), and (2) generate a file listing in Excel that includes hyperlinks to each file.
Very nice. A nice alternative to my tried and true ‘dir /b /s > List_All.txt’ in the command prompt. Thanks! 🙂
I thought the same thing.
Hey Ana – Good to hear from you. I have that topic on my list, but I was having trouble getting the VBA macro to work correctly. I tabled it for later. You might see it show up at some point.