incert File Names and Titles into Excel

I have over 1,000 files in different formats that I need to incert into excel. I dont need them linked I just need to take the various word documents, excel files, PDF's, power points, etc. capture their file name (that I have created) and their Title (the orginial name they were given at point of creation) and put them into an excel spread sheet. If the only way to do this is with them being linked that is fine. However I do not want to sit at my desk and type out over 2,000 names into an excel file if there is a way to drag and drop them or set up a macro.

Hi.

this is something similar to the below post. Try out the suggestions in the post.

http://www.excelforum.com/excel-prog...-to-excel.html