Have you considered using Spreadsheet::WriteExcel to create all of the reports in one Excel file then using Excel via OLE to print it, thus needing to set your printer settings only once?