Export file names to excel

[integra]

i would like to export the sub-directory file names to excel.
many thanks

[martindwilson]

do you think you could explain that a bit more?

[integra]

i have a sub-directory, ie, d:\my document
there is about 50+ files in this directory and i would like to export the file name (only the name of the file) to the excel file.

[martindwilson]

http://excelexperts.com/VBA-Tips-List-Files-In-A-Folder
has a sheet that will do it for you change the path to suit then delete any unnecessary info
scroll to Download sheet to practise how to List Files In A Folder in Excel or use this link
http://excelexperts.com/sites/defaul...n-a-folder.xls

[integra]

thank you and it solved.. un able to find the "solved" things. always stumble to find it!

[george3]

i would like to export the sub-directory file names to excel.
many thanks

Try that, it will take you 2 sec:
File Names Export