How can I differentiate printers in the same workbook, Excel 2004?

B

burak2102

Hi everyone, here is a tough issue, nobody could answer till now. Hope this
list will be a good ending for this.

Excel 2004. In the workbook X, I've got sheets A and B. I'm trying to define
a macro, but can not achieve. You will run that macro. Sheet A will be
printed through printer 1. And the Sheet B will be printed through printer 2.
There must be a way to differentiate default printers under one command via
visual basic or applescript. I think the one who solves this issue, will be
really really appreciated.
 
C

CyberTaz

I don't think you'll find any way to have half of a print job sent to one
printer & the other half sent to another... The OS doesn't work that way.
Perhaps it would be better to approach from the direction of having your
procedure send the 2 separate jobs sequentially.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 

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

Excel 2008: Can't print certain files to certain printers 4
How to create portable Excel applications? 2
Visual Basic Print to PDF 6
Printing issue, won't print all pages in workbook, seems to send each page separately 1
How can I get a list of the available printer names 4
Merging Workbooks in Excel 2004 for Mac 1
Macro for solver on certain worksheets 2
Excel Combo Box Question 7

Top