Hyperlink text to a specific pg in a pdf file Help

[jhon23]

Hi there, I need help in creating a vba code that looks for any text in column A in sheet1 and looks for it in the pdf file and create a hyperlink.




FYI: I meant to point to the 4 cells.

 

[Belleke]

Hi,
Not exactly an answer to your question, but that is the way I do it.
See example.
The zip file contains an excel file and a Folder named PDF.
1. Unzip
2. Put a few pdf files in the folder
3. open the excel file

 

[jhon23]

thanks @Belleke but this is not what I'm looking for as you can see Cell A4 as the same text as the pdf is there a way that i can create a hyperlink in excel to that specific page that contains that word.

 

[Belleke]

Like this then?
See example
The zip file contains an excel file and a Folder named PDF.
1. Unzip
2. Put a few pdf files in the folder
3. open the excel file