Directory Listing code - Mod?

[mesh1o]

Hello, how can i specify a directory in code and copy all its filing structure, so for every xls file within the folder i specify it will list it in a spreadsheet.

Thanks for your time, RoyUK has a code on his own website for opening the xls files but i want it to list the path.

-RoyUK's Code

[royUK]

Are you using Excel 2007? If you are change .xls to the relevant 2007 extension

Please Login or Register  to view this content.

[mudraker]

You may also find this of interest

http://www.vbaexpress.com/kb/getarti...da54213fdf7d82

It lists all files & sub folders of a directory