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

Answer:

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?