Hyperlink from a cell to a specific page in a pdf document.

I have a table with over 3000 rows and 50+ columns. I use VLOOKUP for accessing the relative information from that table in various forms. The forms are in one workbook and the table is on a different drive in another workbook. The table is grouped by 30 to 50 entries (rows) using a couple of similarities.

On the same drive that holds the table I have a folder with approximately 100 pdf files. Each unique file represents each of the groups of 30 to 50 entries. Each pdf file has between 2 and 50 pages with all pages as images only. Each page is represented by one row in the table. All grouped by the same similarities.

I want to use a hyperlink to be able to access the specific page of the pdf file that represents that row. Either I can create another column in the table with those links. The new column will have to have formula that I can “fill down” to extend to the thousands of rows. So in my new form I can click on the results of a VLOOKUP link to access that one page that holds the information in the pdf document representing that row.

I have tried making the links in the table. And have tried:

BioData\Agloway.pdf#page=4

And

BioData\Agloway.pdf#targetpage=4

BioData is my folder name where the pdf documents live.

Agloway is the pdf file.

When I use this formula it only takes me to the first page of the pdf document.

Or it would probably be better for a hyperlink to access the pdf from the form itself rather than having all those hyperlinks in the table.

In one of the forms I use the formula: =HYPERLINK("#"&IFERROR(CELL("address",INDEX([Capiz.xlsm]Info!$D$5:$D$5027,MATCH(AN9,[Capiz.xlsm]Info!$D$5:$D$5027,0))),""),IFERROR(INDEX([Capiz.xlsm]Info!$D$5:$D$5027,MATCH(AN9,[Capiz.xlsm]Info!$D$5:$D$5027,0)),""))

That link takes me to the table to one of the cells in the row that I want.

I just need to be able to use the same basic idea to open the page in the pdf document corresponding to that row.

Idealy, it would be great to have the image on the pdf page into a cell on my form. Rather than having a separate window for the image. I can live with a separate window but all in one is better.

Too much?

Last time you guys helped me a lot so thanks ahead for the help this time.

Dennis

Thanks for the reply but turning about 100 pdf files into over 3000 and renaming them to correspond to the right excel entry seems too labor intense for my needs.

I will have to come up with another solution.

Thanks again, Dennis