Need a macro to include file names in a folder to excel sheet

[anil]

Hi all,

I need a macro with which i can copy all the file names( other than
Excel files) in the folder to a excel sheet and creat the Excel sheets
of the same names included in the excel sheet


Thanks and regards
anil.hungund