Finding full file path from list of files in excel

Hi,

I have used a macro to display a list of files contained within a directory and its sub-directories. What i now need is to report the full file location path for each of the files in the list. I used the following macro to find the filenames:-

Please Login or Register  to view this content.

Any help would be appreciated. Thanks!!