Vba list all files in a folder in Excel

I want to run a macro to list the names of all files in a folder in a worksheet. I want the file names along with extensions. Please help


Use the VBA commande Application.Filesearch. See some good examples in the following link.

(for formulas, depending on your country, you might have to change ; with , or the opposite

 Other excel answers



You can find similar Excel Questions and Answer hereunder

1) Generate a list of unique values in Excel

2) How can I set up a drop down list?

3) How can I loop through all ActiveX checkboxes in WorkSheet and set them to Unchecked status?

4) How can I change the Marker size and Marker line color for all the series in a chart?

5) How can I loop through all WorkSheets and get their names using VBA?

6) How to change desktop background in Excel

7) String split in vba in Excel

8) How can I copy and rename a WorkSheet using VBA?

9) Excel 2010 vba replacement of application filesearch in Excel

10) How can I get users to select a file for processing using my macro?

11) How can I dynamically add series to an existing chart using VBA?

12) How can I remove display of Gridlines in my worksheet using VBA?

13) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

14) Vba delete entire row if contains certain text in Excel

15) How can I protect / unprotect WorkSheet using VBA?