Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro to set duplex option
I have a printer with a duplex option and I need to have the option work on
workbooks with multiple worksheets. Using the group feature and selecting the duplex option doesn't work because each worksheet must have the duplex option turned on before selecting the group feature in order for the duplexing option to work. And, when the duplex option is selected, it turns off whenever a different printer is selected for any other open workbook. The duplexing option will save properly, but when a workbook with the duplexing option saved to it is opened and any other printer is selected for any other open workbook, the duplexing option is turned off for all worksheets for open all workbooks using the duplexing option. My intended solution was to create a macro to turn the duplexing option on quickly. However, when I've tried this, the macro changes all the available print options that Excel knows about and doesn't turn the duplexing option on. Is there any way that you're aware of to use a macro for this problem? If not, do you know of anything else that might help? I admit that I have very limited VBA programming skills. I am an accountant by trade and use Excel extensively. I appreciate your help on this and appologize for my lack of programming skill. Will Fleenor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro to set duplex option
Can you create another "printer" (print driver that goes to this printer in
Start=Settings=Printer) that has the duplex option set. Then you would just select this printer. This would be the easiest if it works. Another think you can look at: http://support.microsoft.com/default...b;en-us;230743 HOWTO: Set Duplex Printing for Word Automation -- Regards, Tom Ogilvy "Will Fleenor" wrote in message ... I have a printer with a duplex option and I need to have the option work on workbooks with multiple worksheets. Using the group feature and selecting the duplex option doesn't work because each worksheet must have the duplex option turned on before selecting the group feature in order for the duplexing option to work. And, when the duplex option is selected, it turns off whenever a different printer is selected for any other open workbook. The duplexing option will save properly, but when a workbook with the duplexing option saved to it is opened and any other printer is selected for any other open workbook, the duplexing option is turned off for all worksheets for open all workbooks using the duplexing option. My intended solution was to create a macro to turn the duplexing option on quickly. However, when I've tried this, the macro changes all the available print options that Excel knows about and doesn't turn the duplexing option on. Is there any way that you're aware of to use a macro for this problem? If not, do you know of anything else that might help? I admit that I have very limited VBA programming skills. I am an accountant by trade and use Excel extensively. I appreciate your help on this and appologize for my lack of programming skill. Will Fleenor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro to set duplex option
I fugured it out.
SendKeys "%fp%r{TAB}{TAB}{+}~~", True Thanks, Will "Will Fleenor" wrote in message ... I have a printer with a duplex option and I need to have the option work on workbooks with multiple worksheets. Using the group feature and selecting the duplex option doesn't work because each worksheet must have the duplex option turned on before selecting the group feature in order for the duplexing option to work. And, when the duplex option is selected, it turns off whenever a different printer is selected for any other open workbook. The duplexing option will save properly, but when a workbook with the duplexing option saved to it is opened and any other printer is selected for any other open workbook, the duplexing option is turned off for all worksheets for open all workbooks using the duplexing option. My intended solution was to create a macro to turn the duplexing option on quickly. However, when I've tried this, the macro changes all the available print options that Excel knows about and doesn't turn the duplexing option on. Is there any way that you're aware of to use a macro for this problem? If not, do you know of anything else that might help? I admit that I have very limited VBA programming skills. I am an accountant by trade and use Excel extensively. I appreciate your help on this and appologize for my lack of programming skill. Will Fleenor |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro to set duplex option
Thanks, this is a better solution than the macro I came up with.
Thanks, Will "Tom Ogilvy" wrote in message ... Can you create another "printer" (print driver that goes to this printer in Start=Settings=Printer) that has the duplex option set. Then you would just select this printer. This would be the easiest if it works. Another think you can look at: http://support.microsoft.com/default...b;en-us;230743 HOWTO: Set Duplex Printing for Word Automation -- Regards, Tom Ogilvy "Will Fleenor" wrote in message ... I have a printer with a duplex option and I need to have the option work on workbooks with multiple worksheets. Using the group feature and selecting the duplex option doesn't work because each worksheet must have the duplex option turned on before selecting the group feature in order for the duplexing option to work. And, when the duplex option is selected, it turns off whenever a different printer is selected for any other open workbook. The duplexing option will save properly, but when a workbook with the duplexing option saved to it is opened and any other printer is selected for any other open workbook, the duplexing option is turned off for all worksheets for open all workbooks using the duplexing option. My intended solution was to create a macro to turn the duplexing option on quickly. However, when I've tried this, the macro changes all the available print options that Excel knows about and doesn't turn the duplexing option on. Is there any way that you're aware of to use a macro for this problem? If not, do you know of anything else that might help? I admit that I have very limited VBA programming skills. I am an accountant by trade and use Excel extensively. I appreciate your help on this and appologize for my lack of programming skill. Will Fleenor |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro to set duplex option
This didn't help me. I have a HP LaserJet 2200d which has the duplex
function. Can you explain what this command does? When I inserted it into my macro, I got an error message. "Will Fleenor" wrote: I fugured it out. SendKeys "%fp%r{TAB}{TAB}{+}~~", True Thanks, Will "Will Fleenor" wrote in message ... I have a printer with a duplex option and I need to have the option work on workbooks with multiple worksheets. Using the group feature and selecting the duplex option doesn't work because each worksheet must have the duplex option turned on before selecting the group feature in order for the duplexing option to work. And, when the duplex option is selected, it turns off whenever a different printer is selected for any other open workbook. The duplexing option will save properly, but when a workbook with the duplexing option saved to it is opened and any other printer is selected for any other open workbook, the duplexing option is turned off for all worksheets for open all workbooks using the duplexing option. My intended solution was to create a macro to turn the duplexing option on quickly. However, when I've tried this, the macro changes all the available print options that Excel knows about and doesn't turn the duplexing option on. Is there any way that you're aware of to use a macro for this problem? If not, do you know of anything else that might help? I admit that I have very limited VBA programming skills. I am an accountant by trade and use Excel extensively. I appreciate your help on this and appologize for my lack of programming skill. Will Fleenor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplex Printing Macro | Excel Worksheet Functions | |||
macro for button option | Excel Discussion (Misc queries) | |||
I want to duplex a workbook | Excel Worksheet Functions | |||
Do not print in duplex | Excel Programming | |||
Disable Macro Option | Excel Programming |