How can I create hyperlink list of folders and files in a directory in excel

[Stevenegoad]

I have a folder(instruction bulletins) that contains dozens of folders(manufactures) with each containing dozens of folders(devices) and dozens of PDF files(manuals) and I wish to create a excel workbook that contains hyperlinks to all of these PDF files so that I can search through them and click on a hyperlink which will take me to the PDF file.

[royUK]

See this

[Stevenegoad]

Thanks but this does not get the sub folders and their files.

[NoS]

The code here may be something to have a look at.

[Stevenegoad]

Thanks as this is what I was looking for plus some!