Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I just purchased a new Laserjet 1320tn printer and would like to know if
anyone knows how to access the printer properties thru VBA. I run various VBA macros when printing reports from several worksheets and would like to be able to turn duplex printing on and/or off as well as select which tray I'm pringing from. All I can find in the VBA help is the ActivePrinter which I use to select the printer I want to use and ActiveWindow.SelectedSheets.Printout to set some options (copies, collate, etc.). Any help would be greatly apprecitaed. Carl White |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting Tab Properties in Excel | Excel Discussion (Misc queries) | |||
Setting properties of userform controls with VBA | Excel Programming | |||
Setting properties to combobox | Excel Programming | |||
Setting up default chart properties | Excel Programming | |||
setting properties for shapes | Excel Programming |