Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Prints the first two pages of the worksheet named Summary in the workbook named Planning xls to a file named Planning Summary prn in

Sub printOut()     Workbooks("Planning.xls").Sheets("Summary").printOut From:=1, To:=2, _         PrintToFile:=True, PrToFileName:="\\server\to_print\Summary.prn" End Sub