Want to Pull File Names From Folder into Excel

Hi,

I'm looking for a way to import the names of all the files in a particular folder into excel.

The directory will always be the same so I want it re-scanned automatically every time I open the spreadsheet and then for the names of the files to be imported. Is there an easy way to do this? I've tried grabbing snippets of vba code and fiddling, but nothing is working quite right.

In addition to that, once all of the file names are imported I am wondering if it is possible to delete entire rows based on the extensions listed (ex. ".xml")? Many files are listed two or three times in the directory and I only need ones with certain extensions.

Thanks in advance for any help. I greatly appreciate it!