Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Printing Simplex on a duplex printer.

I was in "record macro" and printed the workbook, then stopped recording to
see what the macro had done. The macro was
ExecuteExcel4Macro _
"PRINT(1,,,1,,,,,,,,3,""\\PRINTEC\PEC003 on Ne02:"",,,,TRUE)"

I want to print simplex on a printer define as duplex. The above work for
the first sheet of the workbook, then it goes back to duplex. I am thinking
that one of the parms I am not using may make this work. Is there somewhere
that I can find out what these parms mean (particularly those I am not using
-- yet). I can copy this macro and specify each sheet; one-at-a-time like
this:
Application.ActivePrinter = "\\PRINTEC\PEC041 on Ne03:"
Sheets("Elec_BS").Select
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,""\\PRINTEC\PEC041 on
Ne03:"",,,,FALSE)"
Sheets("Elec_IS").Select
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Sheets("EStat_1").Select
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Sheets("custconsump").Select
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"

But there must be an easier way. Besides, I don't want to have to maintain
this when new sheets are added or old stuff removed. Suggestions on making
the simplex persistant?
Thank you
Reply
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 Duplex NeedAnAnswerForMyBoss Excel Discussion (Misc queries) 3 March 5th 08 04:59 AM
Duplex printing reno Excel Discussion (Misc queries) 3 August 25th 06 05:37 PM
duplex printing multiple worksheets Darlene Excel Discussion (Misc queries) 0 July 19th 06 02:33 PM
Printing all worksheets in a workbook using a duplex printer dott Excel Discussion (Misc queries) 1 November 30th 05 11:20 PM
How can I do duplex printing in excel with a HP2430dtn? Von Excel Discussion (Misc queries) 1 February 17th 05 04:28 PM


All times are GMT +1. The time now is 10:12 AM.

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

About Us

"It's about Microsoft Excel"