If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
hyperlink printing excel
Hello, In my sheet I've got a list of hyperlinks linked to pdf files. I wondered if it was possible to automate printing of these pdf files by clicking on an adjacent cell. So i was thinking, in one cell you have the hyperlink to the pdf file and in the cell next yo it you can print it automatically by clicking there. Thanks for any help!! -- deer |
#2
|
|||
|
|||
hyperlink printing excel
No problem having a macro run when you click in the cell, and picking
up the filename of the PDF file. What I haven't found (in 20 minutes of looking) is a way to cause it to print. If you can find a means by which Excel can cause it to print I can help with the rest! Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
hyperlink printing excel
An interesting approach might be to not use hyperlinks to open the pdf file.
If Acrobat were opened with: adobe acrobat 8.0 type library Then the VBA could tell Acrobat to open the pdf file and then print it. -- Gary''s Student - gsnu200816 "Bill Manville" wrote: No problem having a macro run when you click in the cell, and picking up the filename of the PDF file. What I haven't found (in 20 minutes of looking) is a way to cause it to print. If you can find a means by which Excel can cause it to print I can help with the rest! Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|