I'm trying to write some code that creates a hyperlink to a saved PDF file. I want the code to take the contents of a cell and lookup the respective PDF file in a folder on the local hard drive. So far I have only been able to find ways to create a list of hyperlinks(excel list a hyperlink for every file in the folder), but I want the code to be able to create a hyperlink for the just a specific file that changes depending upon what the user inputs into a certain column that I have already stored as a string as "BldgCd". All of this will go in the active cell of the worksheet, so there is no remote range that hyperlink needs to go to. Any code will help tremendously. Thanks.
Posted by jaf89f on
There are currently no replies to the "Hyperlink to saved PDF's" topic of the Excel Help Forum for Automating Data Analysis Tasks.
