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
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