May 26th, 2022

VBA 2010 – 096: FileSystemObjects

File System Objects allow you to search folders on your drives for files from Excel. In this tutorial we use it to create a list of all files in a drive.
Download the samples for this series for free!

All our tutorial samples are free however if you appreciate our work and would like to make a voluntary donation then please do.

Recommended Reading

Both the below books by John Walkenbach are fantastic books and he is a brilliant author, I would recommend picking one of these books up even if just for a reference. I have read power programming cover to cover and it is easy to follow and is a must have for any serious VBA programmer.

If you have read any books and feel they are worth recommending then please post about them on our Forum.

VBA 2010 – 095: Open a Workbook

VBA 2010 – 097: Open all files in a Folder

One Comment

  1. Alex
    November 6, 2017

    Hello Matthew,

    For your inforatinon, in this sub procedure Count is not declared with a dim which makes the application fail, at least in VBA 2013.

    All the best with your tutorials site, very much detailed and useful videos.


Leave a comment

Your email address will not be published. Required fields are marked *