Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing all embedded PDFs in Excel

Status
Not open for further replies.

davis07

Technical User
Feb 10, 2007
4
US
I am trying to create a macro command that would format an Excel document into one page, autowrapping all cells then print the worksheet and all embedded PDFs one-by-one.
For printing the PDFs, I'm thinking something similar to the following code could work, but this has some bugs and I'm not sure how to fix...

Sub printembedded()
Dim pdfObj As OLEObject
For Each pdfObj In ActiveSheet.OLEObject
pdfObj.PrintObject
Next pdfObj
End Sub

Any ideas?
Thanks!
--Robert
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top