Getting File Name from a folder.

Question

I want to get the file name from a folder using excel 2007 macros.

Or, I need to list all the files which are belonging inside the folder.

Using excel 2007 macros.