PDF Hyperlink Validation

[SPhe34]

Hello,

I have searched through lots of posts about validating multiple links within spreadsheets, but have yet to see one that works with PDFs. I have have been putting together a spreadsheet with multiple tabs with a few thousand hyperlink formulas per tab. These hyperlinks are to specific pdf documents. I am hoping there is a marco out there that can check thousands of pdfs and let me know which pdf documents are missing so they can be replaced. Any help would be greatly appreciated and save me at least a week of work in clicking each hyperlink and checking for a document.

Thanks!

 

[John_w]

The code at https://www.mrexcel.com/forum/excel...-opens-pdf-file-saved-server.html#post4306238 should be a good starting point. You will need to change it to suit your exact situation.