VBA List Files in Folder

Associated Files Download Links

VBA allows you to list all files from a folder, using the FileSystemObject. In this tutorial, you will learn how to get names of all files in a folder and put them into a Worksheet.

If you want to learn how to check if a file exists, you can click on this link: VBA File Exists 


Using the FileSystemObject to Get the List of Files in a Folder

We will show how to get a list of files in the folder C:\VBA Folder and put it into the first column of the Worksheet. This folder consists of 5 files, as shown in Image 1:

Image 1. Files in folder C:\VBA Folder


Here is the code:


In the example, you first need to create the object of the class Scripting.FileSystemObject:


Then you have to set the folder using the method GetFolder of the class to the oFolder:


Now you can loop through oFolder, in the attribute oFile.Name get the name of every file in the folder and write it in the next empty row:


Image 2. Worksheet with the list of files in the folder


As you can see in Image 2, all 5 files from the C:\VBA Folder are listed in the first column.