print hyperlinked file

[Jeff-Q]

I have a spreadsheet with a large range of data that includes hyperlinks to pdf files. A Word document links to information in this spreadsheet and a report is printed. I'd like to add a feature to the report that prints the hyperlinked PDF files that are associated with the reported excel data. Does anyone know how I might accomplish this.

To summarize: I want to print a MS Word document that contains data linked to Excel (no problem). In the excel spreadsheet, there is a hyperlink to a pdf file for each data item. I'd like the reported data specific hyperlinked pdf files to print with the word report.

Any suggestions or help is very much appreciated.

Thanks,

Jeff

 

[hatman]

Well, if this works like any other application, i would start by adding a reference to the latest version of teh Adobe Acrobat Type Library (I have 7.0), then define an Early Bound object, and start playing.

Here is an article to give you a flavor of how to get started, though it seems to be an older version (5.0) http://www.igetit.net/SampleCode/Adobe_Acrobat_vba_code.asp

 

[Jeff-Q]

Thanks for your response.

The article looks a bit advanced for me... I'll have to take some after hours time to study it and see if I can figure it out. I usually create VBA scripts first by recording keystrokes. I can figure some of the programming out and get by, but at a very basic level.

Thanks again... I'll check it out.