• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need guidance as to what is possible with printing macro`s

P

Peter Groves

New Member
For now I`d just like to know what the possibilities are to print a selection of sheets, to a selection of several possible printers. There is also the issue of color printing, B/W and paper selection.

I`ll put sheet selection labels with check boxes and printer selection boxes on a page
and when you press print it will print the sheets to the proper printer and parameters.

Something like (selections for sheet 2 & 3 omitted due to lazyness).

Sheet 1 x sheet 2 Sheet 3 x etc

\\main\hp9610
\\main\canon12
\\main\Lex7112 x

8x11
8x14
11x17 x

color y/n y


Click HERE to print




All I expect are few ideas to point me in the right direction for now.

Thanks in advance

Pete
 
Hi Pete,

All of what you described is possible. Easiest way to write the code would be to actually record a macro of you doing each of the actions, and then reviewing what gets written. That should show you how to change printers, and/or how to change the print settings.

Small note, communicating to the printer to change settings is not a fast process, so having lots of code that changes page setups or print settings will take awhile to run through.
 
You must log in or register to reply here.
Back
Top