LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Printing Via By Macro for Network Printer

Hello,
I am in need of some help. I have searched this group and found a macro that
has allowed me to print to a certain printer, even if it is the default one.
However I wish to expand on it to allow me to chose how many copies I want
and whether I want it double sided.
I have found that if I use copies:=# in the programing, I can have a button
work, but I don't want to make seperate macro buttons for 1x 2x 3x ... 6x.
I have not been able to find how to double-side print. I have my default for
that printer double-side, but it does not always do this. :(

So in final, summary.
I want to have the page print to a certain printer, which is working inside
the macro okay (automatically switches and then returns to default printer,
as required). Once the macro is pressed an option pops up for number of
copies. Double-sided will be within the macro program.

Hope that explains it. Regards Kevin.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing macro i network Mia Excel Programming 7 March 2nd 10 06:07 PM
Creating a macro to print to file when printing to another printer [email protected] Excel Programming 1 July 12th 08 09:04 PM
members on my network printer not able to print to default printer smeheut Excel Discussion (Misc queries) 0 June 18th 07 06:42 PM
Choosing printer in a printing macro Werner[_18_] Excel Programming 1 July 5th 05 04:52 PM
Choosing printer in a printing macro \Jean-Jerome Doucet via OfficeKB.com\ Excel Programming 2 July 5th 05 04:31 PM


All times are GMT +1. The time now is 01:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"