PDF Hyperlinking Macro Excel 2010

Hello all,

Back in 2008, with the help of some of the members here, we were able to create a macro that would hyperlink all the pdf files in a specified folder and display them in descending order in the excel spreadsheet as their file names. I believe it was Excel 2003 that I was using at the time. I am now looking to use this macro for Excel 2010 and am running into Run-time error '438'.

Is anyone able to suggest a solution for this? If so, my company would greatly appreciate it as it was an incredibly useful tool back when it was working properly.

Thank you very much and I look forward to your responses/suggestions. I've attached the old code below.

Paul B

Please Login or Register  to view this content.

Anyone able to have a closer look and offer any ideas or a solution to this?

Originally Posted by abousetta

Here you go:

Please Login or Register  to view this content.

Enjoy

im not even a part of this thread but THANK YOU!!!! this has helped me to no end!

thanks again REPPED

YES! THANK YOU SO MUCH! Working perfectly as intended. You literally just shaved off weeks of hyperlinking because we scan and log EVERYTHING here. You made my day, abousetta.

Again, thank you so very much!

this routine strips zeros off filenames. How do I preserve the leading zeros - mostly 3 of them.