print macro with selected options

hi,

is it possible to create a macro that prints the active sheet with the following print conditions

1. print to "microsoft pdf" printer
2. pages 1-10 only
3. selected page size is FOLIO (8.5" x 13")
4. landscape

If you record a macro of you choosing those settings and printing it will get you most of the way. To get it to auto print to a specific printer adds a kink into it, though. With a function from here, I put this together and it seems to work.

You'll need to change the ".PaperSize" reference, since I don't have a Folio (8.5x13) option on my PC. Tabloid is 11x17. Also, if you try first by recording a macro, you'll see a plethora of additional PageSetup options you can change within VBA (margins, headers, etc.)

Please Login or Register  to view this content.