Get file names from a folder using Excel VBA

Get name of the files in a folder

This is an Excel 2007 or later macro that can fetch the name of all the files in a folder.

1. Download the file and open in Excel 2007 or later. If the macro security is not set to Low, you will be asked to Enable macros. Go ahead and enable the Macros.
2. Click the button labelled "Get File Names from a folder"
3. A warning message will pop up saying that the existing data in sheet 1 will be deleted. Click OK
4. A dialog will open allowing you to browse the folder where your files are.
5. Click OK and there you go!!