printing pdf hyperlinks

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.

Example Excel sheet:

-colA----colB-----colC-----colD
data1 data1b data1c data1.pdf (hyperlink)
data2 data2b data2c data2.pdf
data3 data3b data3c data3.pdf
data4 data4b data4c data4.pdf
...

Example Word Report:

[PAGE1]
Report List

data4......data4c
data1......data1c
data3......data3c
-----------------------------------
[PAGE2]
c:\mydocs\data4.pdf (not necessarily embedded as an image in word, although that would be acceptable, but I just would like this to print after the report. This word report is a template that changes based on changes to the excel spreadsheet.)
-----------------------------------
[PAGE3]
c:\mydocs\data1.pdf
-----------------------------------
[PAGE4]
c:\mydocs\data3.pdf


Any suggestions or help is very much appreciated.

Thanks,

Jeff
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

McQuinge

New Member
Joined
May 16, 2008
Messages
41
I hope someone can see this post and come with some suggestions.
I'm having the same challenge.
 

Forum statistics

Threads
1,136,649
Messages
5,676,990
Members
419,667
Latest member
MegEri

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