print hyperlinked file

Jeff-Q

New Member
Joined
Feb 25, 2005
Messages
13
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
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

hatman

Well-known Member
Joined
Apr 8, 2005
Messages
2,664
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

New Member
Joined
Feb 25, 2005
Messages
13
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.
 

Forum statistics

Threads
1,136,269
Messages
5,674,743
Members
419,525
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top