Programmatically printing x pages/sheet

  • Thread starter Thread starter R Avery
  • Start date Start date
R

R Avery

Excel 2002.

Where is the setting to programmatically print a specified number of
pages per physical sheet of paper in VBA? I recorded a macro, but did
not see the proper property there. Also, I do not see it in the Object
Browser. I am specifically talking about File | Page Setup... | Options
| Pages per sheet.

Any help would be most appreciated.
 
PrintOut method:

Private Sub CommandButton1_Click()
'expression.PrintOut(From, To, Copies, Preview,
ActivePrinter, PrintToFile, Collate, PrToFileName)
Worksheets("Sheet1").PrintOut , copies:=3
End Sub
 
No, that is how to specify multiple copies of the same document be
printed. I want page 1 and 2 of the printed document printed on the
same physical piece of paper.
 
It looks to me like when you click options in the Page Setup dialog it takes
you to properties for your specific printer which would not be part of
Excel, so I don't think it would be part of the Excel Object model. When I
click options I do not even see an option to print 2 pages on one piece of
paper.

Sue
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing The "Printing Sheets Per Page" In VBA? 3
Print entire workbook with each sheet starting at page 1 8
Print 2 pages per sheet 3
VBA solution for printing specific pages 3
print 2 sheets on one paper 5
Need help formatting a sheet 0
Controlling Page Break Preview 7
Mac Excel 2001 and PageSetup.PaperSize = xlPaperLetter 1

Back
Top