[AccessD] How to List Files in a folder and then Select a Specific File using Access 2007 VBA

All,

I am working on an Access 2007 application which will obtain data from one of multiple Excel files.

I would like to be able to list all of the Excel files in one folder and then obtain the name of the file that is selected by the user.

I have been experimenting with "Application.FileDialog" but keep running into problems.  I have very little experience in this realm. 

Does anyone have an example of how to do this or possibly a link to a good example on the web?

Thanks,

Brad