Return full file path for files in directory

Could you point me in the right direction for code which will return the full file path of files in a directory plus the path of a sub directory files?

Hello Jeff,

You can use the File System Object, part of the Microsoft Scripting Runtime library, to do both tasks. You can a reference in your VBA project to the library (early binding which provides Intellisense) or late bind by using...

    Set FSO = CreateObject("Scripting.FileSystemObject")

Thanks Leith.

That info did the trick...I found this site and with your suggestion...perfect.

http://www.exceltip.com/st/List_file...Excel/446.html

Thank you for your time