Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to change duplex setting?
We have one spreadsheet that has about 15 tabs. I would like to add to my
macro some code that would print some of these spreadsheets duplex and some simplex. create a macro to print these 15, with some being printing simplex and others printing duplex. The printer is set up to do duplex as default. I don't want the user to have to change printer properties before printing each sheet. So is there a function I can put in my macro like "printeroptions.duplex.enable" and "printeroptions.duplex.disable" that I would put right before "ActiveWorkbook.ActiveSheet.PrintOut" that would allow me to switch like this? On the user's side, all I want him to have to do is start the macro. Thank you, jerrybdot |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to change duplex setting?
The supported options are
Sub PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName], [IgnorePrintAreas]) jerrybdot wrote: We have one spreadsheet that has about 15 tabs. I would like to add to my macro some code that would print some of these spreadsheets duplex and some simplex. create a macro to print these 15, with some being printing simplex and others printing duplex. The printer is set up to do duplex as default. I don't want the user to have to change printer properties before printing each sheet. So is there a function I can put in my macro like "printeroptions.duplex.enable" and "printeroptions.duplex.disable" that I would put right before "ActiveWorkbook.ActiveSheet.PrintOut" that would allow me to switch like this? On the user's side, all I want him to have to do is start the macro. Thank you, jerrybdot |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to change duplex setting?
Thanks. Yes, I know the PrintOut options but those do not give me what I
need. I was looking for some function/method/property . . . that would allow me to switch between duplex and simplex from within a macro. "Bob I" wrote: The supported options are Sub PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName], [IgnorePrintAreas]) jerrybdot wrote: We have one spreadsheet that has about 15 tabs. I would like to add to my macro some code that would print some of these spreadsheets duplex and some simplex. create a macro to print these 15, with some being printing simplex and others printing duplex. The printer is set up to do duplex as default. I don't want the user to have to change printer properties before printing each sheet. So is there a function I can put in my macro like "printeroptions.duplex.enable" and "printeroptions.duplex.disable" that I would put right before "ActiveWorkbook.ActiveSheet.PrintOut" that would allow me to switch like this? On the user's side, all I want him to have to do is start the macro. Thank you, jerrybdot |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to change duplex setting?
That "option" isn't supported. You may effect the same result by
creating one instance of the printer with Duplexing "On", and one instance with it set to "Off". Then you may select the desired one to print to in your VBA. jerrybdot wrote: Thanks. Yes, I know the PrintOut options but those do not give me what I need. I was looking for some function/method/property . . . that would allow me to switch between duplex and simplex from within a macro. "Bob I" wrote: The supported options are Sub PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName], [IgnorePrintAreas]) jerrybdot wrote: We have one spreadsheet that has about 15 tabs. I would like to add to my macro some code that would print some of these spreadsheets duplex and some simplex. create a macro to print these 15, with some being printing simplex and others printing duplex. The printer is set up to do duplex as default. I don't want the user to have to change printer properties before printing each sheet. So is there a function I can put in my macro like "printeroptions.duplex.enable" and "printeroptions.duplex.disable" that I would put right before "ActiveWorkbook.ActiveSheet.PrintOut" that would allow me to switch like this? On the user's side, all I want him to have to do is start the macro. Thank you, jerrybdot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change Automatic sum setting from 17.5% to 15% | Excel Worksheet Functions | |||
change from left-to-right as default setting | Setting up and Configuration of Excel | |||
change language setting using VBA code | Excel Worksheet Functions | |||
Change the default $ setting to ‚¬ on invoice template? | Excel Discussion (Misc queries) | |||
Change radians - degrees setting | Excel Discussion (Misc queries) |