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.



Download Sample Files

    I am very passionate about helping legal professionals succeed. I even quit my day job to devote more time to mentoring! I want to encourage you to subscribe and join the LitSuppGuru community. I share humorous, informative, and time-sensitive emails above and beyond what appears on this site.

    Please note: I reserve the right to delete comments that are salesy, offensive or off-topic.