hyperlink printing excel deer <deer.3687d47[ at ]excelbanter.com> 11/18/2008 8:31:06 AM 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

Re: hyperlink printing excel Bill Manville <Bill-Manville[ at ]msn.com> 11/18/2008 4:04:38 PM 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

Re: hyperlink printing excel Gary''s Student 11/25/2008 8:38:20 PM 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: [Quoted Text] > 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 > >