Advanced Printing

**Elvisman** · 08-24-2010, 04:28 AM

Hello,

I'm working on some automations in Microsoft Office Excel 2007 for my companyr, but I got a problem, which I'll try to explain to you clearly:

Given:
- There is one Excell file with 3 worksheets: A, B and C.
- There is one printer with 2 paper sources: source #A# gives blank sheets. Source #B# gives sheets with the company logo on top.

Question: How can I print out the Excell file this way?:
- Sheet A is printed with source #A#
- Sheet B is not printed
- Sheet C is printed with source #B#
- This complete print task will start after clicking one time on the 'OK'-button in the printwindow. Important requirement: you have to only need to open the printwindow once and press the 'OK'-button once.

I'm hoping you could help me with this one. Maybe there are some options in the printwindow I don't know. Maybe there is a site where I could download an addition to the printwindow. Maybe we use the wrong version of Excell. But these are just the things I could think up myself. So the question to you is: is this possible? (and, of course, if yes, how?)

Thank you in advance,
Jeroen Swart

**royUK** · 08-24-2010, 04:38 AM

You would need to change the printer using Activeprinter

wanrom · 08-25-2010, 07:44 PM

thanks for the help, i was looking almost for same

**Apachewar** · 08-28-2010, 04:58 AM

sorry wrong thread.

**royUK** · 08-28-2010, 06:25 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.