Linking Excel to Acrobat 8 Bookmark?

In order to link to a specific page from another application, you can append an open parameter to the link. For example:
www.adobe.com/AcroJS_DesignerJS.pdf#page=24

For more information visit the following tip at:
http://www.acrobatusers.com/tech_corners/loris_corner/dear_lori/2006/hyperlink_to_pdf/

Lori,

Thanks for the reply. The example you gave relates to linking to a PDF document on a web page. How do you get it to work if the PDF document is just on your hard drive?

Thanks!

This is explained in more detail in the PDF Open Parameters in the tip mentioned above. Here is an example:
Acrobat.exe /A "page=2" "C:\example.pdf"

Lori,

Sorry to be a pest.

But say my pdf file on my hard drive is test.pdf and I want to go to page 5, what is the exact string that I need to add to the EXCEL cell to link to test.pdf, open it, and have it go to page 5?

Thanks.

If you're in Excel you can do the following:

=HYPERLINK("C:\folder\sample.pdf#5")

or you can go to a Named Destination within the PDF

=HYPERLINK("C:\folder\sample.pdf#nameddestination")

Lori,

It does not work.

Here is the exact command and filenames etc. I am using.

acrobat.exe /A "page=5=OpenActions" "E:\sept 20\Feb 18\CCII\CCII Hansen...150000.pdf"

When I put this string in Start/Run and execute it, it works like a charm, i.e., Hansen...150000.pdf opens up to page 5.

When I put that exact string into excel as a hyperlink, it comes back with the following error, "Cannot open the specified file."

I think it is choking on the extra double quotes that are needed for the open parameters.

Actually, you shouldn't need to run the entire command -- just append the page number after the PDF filename like this:

=HYPERLINK("E:\\sept 20\Feb 18\CCII\CCII Hansen...150000.pdf#5")

If you're experiencing difficulties with the quotes in the string try adding the following in Excel:
File --> Properties --> Summary Tab
Under Hyperlink base add E:\

You'll need Acrobat 7.0.8 or later because there was a bug in earlier versions of Acrobat 7.0 and Adobe Reader 7.0 that searched only web servers for PDF files that are linked to Office documents via hyperlinks. Acrobat 7.0.5 and Adobe Reader 7.0.5 search web servers, local drives, and shared drives for linked PDF files.

Lori,

I did all those things. The file opens - but to page one - *not* page 5.

Maybe it just isn't meant to be. But it is such a simple thing that I would imagine a lot of folks run across, i.e., link me from Excel to a PDF file sitting locally on my machine or on a CD/DVD.

It works when the file is on the web but not when the file is local.

It seems that Excel is ignoring everything after the # sign. You can put gobbly gook after the # sign and it will still open the file and go to page one. But if you change the # to say a @ then u get the dreaded "Cannot open the specified file." error message.

I am using Acrobat 8 Pro Version 8.1.2

If you want to give up I certainly understand.

What version of Excel/OS are you using? I had the same problems as you until I added the base URL in Excel. I'm running Excel 2003 on XP. Are you still getting those goofey characters when you put the quotes in?

Lori,

I am running Windows XP Home SP 2, and Excel 2002 (XP).

I am not sure what "quotes" you are referring to.

Hi,
Was there ever a resolution to this problem? I am having the same problem. I am using Acrobat 9, and Excel 2007. I am imbedding the hyperlink in the cell and using a named destination. The correct file opens, but it does not go to the named destination, I also tried using the page number parameter and it ignored that as well. It appears that Excel is stripping off the parameter.