Adapt macro to create list of all PDF files in folder, including subfolders.

Hi all,

I'm looking for a way to modify the code below (found on the MS website) to enable it to return results from all of the subfolders in the directory listed. I have thousands of subfolders in this directory so this would be far too time consuming to run this code individually in each one!

Please Login or Register  to view this content.

Thanks in advance for any help!

Glen

Cytop, that's great - I was hoping to be left with just the filename, but I can run a formula to separate the filename from that in no time.

Millz, I can't get yours to work - it hangs on the "Dim FS As New FileSystemObject" line with a compile error: "User-defined type not defined".

Thanks for the speedy responses guys!

Seems like you are missing out the reference. Try the solution here on how to add the reference.

Ahh beautiful. That did the trick! I now have two identical lists of all of the PDF files in that directory, one from each method (I had already trimmed down the names from cytop's solution). Thanks for both of your answers, they have been most helpful!