Display All Files in Folder in Worksheet

How to display all files in folder in worksheet automatically using VBA. Lst time we learnt how to display all files in a folder in combo-box on a user-form using the FileSystemObject or FSO. The FileSystemobject allows us to access and manipulate files and folder on our computer system quickly and easily using VBA. Watch the video below:

Display All Files in Folder in Worksheet

Here’s the complete VBA code to get all the file names in a folder into a worksheet:

Sub getFilenamesFromFolder()
Dim fso As FileSystemObject, myfolder As Object, myfile As Object
Dim i As Long
i = 2
Range(“A1”) = “File Names”
Set myfso = New Scripting.FileSystemObject
Set myfolder = myfso.GetFolder(“c:\invoices”)

For Each myfile In myfolder.Files
Cells(i, 1) = myfile.Name
i = i + 1
Next myfile
End Sub

Published by

Dinesh Kumar Takyar

Welcome to exceltrainingvideos.com! My aim is to help you learn MS Excel including VBA. I always felt that a good way to learn something was to find solutions to problems in that domain. That is why I share these Excel videos with you. Mostly these are questions asked during my corporate training sessions. I've been training individuals and companies in computers since 1991. I did my B. Sc. (Vordiplom), M. Sc. (Diplom) and Ph.D. (Dr. rer. nat.) from Hamburg, Germany. The best thing about solving some of my visitor's questions is that I also gain new insights. For more Excel VBA solutions you may like to visit my YouTube channel: http://youtube.com/familycomputerclub For a structured Excel VBA training course online you can visit: https://www.youtube.com/excelvbaonline

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.