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

pdf that is updated by an excel document each time it Is opened?

blennon
Registered: Jan 11 2010
Posts: 2

Hi there,

I am a very light weight user and a little out of my depth here but! I want to create a .pdf that is updated by an excel document each time it Is opened. Is this possible? I am currently using LiveCycle 8 and acrobat 8 pro but have just ordered the CS4 suite, does this help

Thanks
Barry

thomp
Expert
Registered: Feb 15 2006
Posts: 4411
This is absolutely possible, but only for a PDF on the same machine as the excel file. The easiest way to do this, with as little scripting as possible, is to create a livecycle form and use the data view tab to connect it to excel file. You'll need to learn a little bit about using data sources in a LiveCycle form. And you'll need to create a named area on the spread sheet. This name is required by the driver that connects to the spreadsheet, so that it can reference a specific set of data in the spreadsheet.

It doesn't get much simpler that this.

so what exatly do you want to get updated? a dropdown list? Or do you want to get a specific entry out of the spread sheet?

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Then most important JavaScript Development tool in Acrobat
[url=http://www.pdfscripting.com/public/34.cfm#JSIntro][b]The Console Window (Video tutorial)[/b][/url]
[url=http://www.acrobatusers.com/tutorials/2006/javascript_console][b]The Console Window(article)[/b][/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script