Dear all,

I have a folder with many sub-folders within it.

Inside this folder contains around 100 word documents and 50 pdf files.

1. How do i write a VBA code to first extract all the filenames inside this folder and within the sub-folders, and display it on a Excel worksheet?
2. Secondly, i would want to extract out all the hyperlinks inside these word documents and pdf files and display them beside the filenames?

Any recommendations on how to do this?

Thanks
cihow81