Hyperlink to a specific page of an pdf on same comuter

Hi,

please help me with this problem of mine:

I have an excel-file with a lot of page-numbers of pdf's. I want to open the pdf on specific pages.

Problem is: Adobe Acrobat is not able to open a pdf and then go to a specific page, if the pdf is not "on the Internet", but on the same computer, i.e. this does not work: "#page=[page number]" (see: https://helpx.adobe.com/acrobat/kb/l...e-acrobat.html).

First possible solution may be modifying the hyper-link in a way that Acrobat it "thinks" the pdf is "on the Internet", but is in fact on the same computer. Is this possible?

Second possible solution may be using VBA: There are a lot of macros out there trying to solve this problem. For example this one:

Please Login or Register  to view this content.

(source: Michael (Micky) Avidan at: http://excel.tips.net/T003350_Linkin..._PDF_File.html)

In my excel-file (see below: "pdftest.xlsm" or without macro inserted: "pdftext.xlm") there is a column (column L), that lists the pdf-files. For example L2 is "Test_31", which refers to the file "C:\Testfiles\Test_31.pdf". In row 2 are the page-numbers for the file "Test_31.pdf". The numbers can have these formats:
a) content of cell M2 is "6". That means Acrobat should open "Test_31.pdf" and go to page "6"
b) content of cell N2 is "15f". That means Acrobat should open "Test_31.pdf" and go to page "15"
c) content of cell O2 is "45ff". That means Acrobat should open "Test_31.pdf" and go to page "45"
d) content of cell P2 is "120-432". That means Acrobat should open "Test_31.pdf" and go to page "120"

Is the following solution possible?: Modify the macro above in a way, that is uses variables, so this happens: When user clicks cell O2, then send this hyper-link "C:\Testfiles\Test_31.pdf" and this page-number "45" to the macro above, so that it should look like this:

Please Login or Register  to view this content.

and then run the modified macro.

Of course any other solution would be great as well.

Thank you very much in advance!

This works for me

Note I had to change the path to the acrobat reader too. the red sections will get you started in regard to making the name and the page number variable but you'll need to give me a bit more guidance on how you want the macro to run. Do you want it to open all those pages you've listed in different windows?

Please Login or Register  to view this content.

Thank you very much for answering!
It is maybe best, to just tell the problem in short (without my theories about how VBA could work).
pdftest.jpg
1) "Test_31" etc are filenames of pdf ("Test_31.pdf" etc.)
2) The numbers in range M2:R4 are page-numbers (or ranges of pages) of the corresponding pdf.
3) Goal is: By clicking a cell in range M2:R4 the corresponding pdf will be opened by Acrobat on the specific page
4) E.g.:
a) Clicking M2 opens Test_31.pdf on page 6
b) Clicking R2 opens Test_31.pdf on page 1498
c) Clicking O3 opens Test_71.pdf on page 123
etc.
5) A new click should replace the old pdf-page with the new pdf-page, so that only one pdf at a specific page is open at a given time.

OK I understand.

Try this. if you click in the page number area it will open adobe to the file in column L and the relevant page number. It works for most the examples I tried. Only issue I found was if the pdf file has spaces in it I had trouble finding it but if it doesn't have spaces it seems to work ok. Not sure why this is!

Please Login or Register  to view this content.

Great. Glad it worked. I learnt a few things too!

I thought it did open in different windows. Mine launches adobe then opens it in an adobe window.

Oh ok. Not sure but I'll look and see what I can do.