LATEST UPDATES
latest

How to export file names from a folder to Excel using VBA

How to export file names from a folder to Excel

How often have we come across the situation where we had a set of folder with numerous files inside them, and we wanted to count the files quickly, and list their name on a Worksheet? Often I guess, pretty often. So here's a macro which let's you do the same, just by clicking a button.

Simply use this code to achieve the same as above:

Now, if you are having trouble implementing this code, I have created a macro enabled workbook that already has this code. You can download it from here.

Do let me know if this helps. And don't forget to join our Facebook group.
« PREV
NEXT »