Printing Question

S

spartanmba

How do I print worksheet pages from various workbooks from one worksheet.
Either an Excel or VBA solution woudld be fine.

Thanks,
John
 
N

Nick Hodge

John

In VBA you could open all the workbooks and then print them, this code opens
two and prints everything in each

Sub PrintOtherBooks()
Dim wb1 As Workbook, wb2 As Workbook
Set wb1 = Workbooks.Open("C:\Book1.xls")
wb1.PrintOut
wb1.Close SaveChanges:=False
Set wb1 = Nothing
Set wb2 = Workbooks.Open("C:\Book2.xls")
wb2.PrintOut
wb2.Close SaveChanges:=False
Set wb2 = Nothing
End Sub



--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top