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