These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Using excel to automate the TOC links to various page numbers within the same document?

Registered: Nov 16 2011
Posts: 1

I am combining several PDF documents in a single file. These files range from 30 to 40 pages. I have a excel template for the table of content. However, I have to update the links to the pages every time.
My question is if I list the page number in a column in my excel spreadhseet, can auto this process. I know you can add a page number to a URL (if you know the PDF file). I would image there would be a way to hyperlink that references itself. For example, in excel the cell formula be something link HYPERLINK(//self.pdf*pg2,Page 2). I am just not sure how to create the link knowing it will be converted into a PDF with links to page 2,3,4 and so on. Thank you.

My Product Information:
Acrobat Pro 10.1, Windows
Registered: Oct 30 2008
Posts: 2398
To create a link within the same file you don't need to specify the file name at all. You just need to set the pageNum property to the number of the page you want to link to (remember this is a 0-based value).

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website:

Registered: Dec 5 2011
Posts: 1
Thank you. I'm also looking for it.

I'm a good singer. I want to share you with some great lists of Easy songs to sing and good songs to sing.