loop trough a folder and get pdf documents also from sub folder but get name of subfolder

Hi all,

I have a macro to list all PDF files on a selected folder, even if there are subfolders there.
The only thing I actually need to add is the name of the subfolder where the PDF file is.

(all subfolders start with a nr in front of it, like: 01 - Primary documents) If a PDF file would be in a folder like 01 - Primary Documents, then I need to add the name of the subfolder too to the sheet.
Now I only get the path where all the PDF files are and not the subfolder.
something like: C:/Documents/126374Peter.pdf
I would like to have it like this: C:/Documents/01 - Primary Documents/126374Peter.pdf

This is my current code:

Please Login or Register  to view this content.

Greetings.

Hi all,

No one wants to help out?

Greetings.