Creating an EXCEL hyperlink to specific point on a PDF page

[Herb Flores]

I have a spreadsheet that is a take off of material, equipment from a PDF print.

I want to create a hyperlink on a excel row cell (example A4) to a control valve on the PDF print. I know how to create hyper links on excel to PDF pages but how do you pin point it to that exact little spot? Even more to several little pin points of the same control valve all at one time?

There's gotta be a way. Please help.

[Paul - PDF-XChange]

Hi Herb,

you may want to look at this document for how to pass parameters to when openng a PDF: http://wwwimages.adobe.com/www.adobe.co ... ers_v9.pdf

I would suggest NamedDestination or a comment.

hth

[Herb Flores]

Thanks Paul,
I just finished reading your attachment and I think it may be over my skill pay grade. When I turn on the show ruler, I can see where the mouse icon moves and how it changes the measures on the top slide and side slide. I still don't have a clue where I could find the coordinates.

I feel dumb.

[Herb Flores]

I am thinking that if I write a macro for the hyperlink in excel, I have to have the input of the exact coordinates of each point to energize it to highlight all of them at one time. Man that is gonna be a doozie.

[Paul - PDF-XChange]

Hi Herb,

in fact getting the coordinate is not trivial. We use the same method as Adobe and it involves calculations that invove the zoom level and DPI of your screen. It is not something that I wold dvve into here.

If you know the page number and can pick a suitable zoom level that might suit. You can pass it directly to the Viewer like this:

C:\Program Files\Tracker Software\PDF Viewer\PDFXCview.exe /A "page=3&zoom=200" "E:\My Documents\Ivan\pdf_open_parameters_v9.pdf"

If I copy/paste that string ino Windows Explorer is opens the document at that page and zoom level. You can use most of the parameters in that document this way. You would need to midofy the path to your document to suit of course.

hth

[Herb Flores]

Thank You Paul,
That does work but the zoom level had to be so high to ID the point that it does not focus on the view it needs to show the location on the system. I tried to make it highlight when it was linked but this is not possible. I would have to write a whole bunch of VBA to make that work.

I have been reading here in the forums looking for interesting stuff. I have the Pro version. Should it have SDK with it or is that a separate buy? I don't know if I would even know how to use it but I would like to find out what it takes.

Thanks Again and Best Regards,
Herb Flores

[Paul - PDF-XChange]

Hi Herb,

you can download the SDK here: https://www.pdf-xchange.com/developers It's free to use as long as you accept the caveate that anything you do with it will result in water marked documents.

Perhaps what would be a better idea is to put a comment at the location of your valve then you can use

comment=commentID
Specifies a comment on a given page in the PDF document. Use the page command before this command.

For example:
#page=1&comment=452fde0e-fd22-457c-84aa-2cf5bed5a349

You can use JavaScript to write some code to get that commentID. I can't hepl you with that JavaScript today but after the easter Week end I expect I can find something for you.

hth

[Herb Flores]

Thanks Paul,

I appreciate your help. Have a great Easter weekend.

[Herb Flores]

Hi Herb,

you can download the SDK here: https://www.pdf-xchange.com/developers It's free to use as long as you accept the caveate that anything you do with it will result in water marked documents.

Perhaps what would be a better idea is to put a comment at the location of your valve then you can use

comment=commentID
Specifies a comment on a given page in the PDF document. Use the page command before this command.

For example:
#page=1&comment=452fde0e-fd22-457c-84aa-2cf5bed5a349

You can use JavaScript to write some code to get that commentID. I can't hepl you with that JavaScript today but after the easter Week end I expect I can find something for you.

hth

I figured it out. I use the rectangle link tool. I set the row number in excel with a link to the exact point and at the point I set 2 links, one to the submittal PDF and the other back to the excel spreadsheet. Now I can toggle several different ways. These prints have detail drawings as well and I set them as toggle points with another rectangle link tool. This totally awesome.

The only problem is when I click on Action, then on add the pane is so big I can't see the whole thing. Is there a cure for that?

Thanks

[Paul - PDF-XChange]

Hi Herb,

The only problem is when I click on Action, then on add the pane is so big I can't see the whole thing. Is there a cure for that?

I think you should be able to use the same fix here as for the Print Dialogue issue described here: https://www.pdf-xchange.com/knowled ... -my-screen

hth

you too have an awesome Easter.

[Herb Flores]

It worked. It was set on 9 and I set it at 8. Perfect fit.

Thank You very much, I am a happy camper now that I can really get done what I need on these projects.

[Stefan - PDF-XChange]