In this post, you’ll learn how to list all files in a Directory in your excel worksheet programmatically using Excel VBA.
How to List all files in a Directory in Excel VBA?
Using the FileSystemObject you can list all files in a folder or directory.
Using the FileSystemObject to Get the List of Files in a Folder
To get the List of Files in a Folder, try using the below VBA code snippet.
For instance, Create a folder in the C drive with the name Excel VBA.
Sub LoopThroughFiles () Dim FSO As Object Dim Folder As Object Dim File As Object Dim i As Integer Set FSO = CreateObject("Scripting.FileSystemObject") Set Folder = FSO.GetFolder("C:\Excel VBA ") (# Mention the exact address of the directory here.) For Each File In Folder.Files Cells(i + 1, 1) = File.Name i = i + 1 Next File End Sub