Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printer Paper Source Setup
Hi, I've gathered through some searching that there's no simple method in VBA
to set the desired printer tray programatically prior to printing a job through a macro, then setting the printer back to it's default tray. I tried building a VB (Visual Studio 2005) app separately allowing command line arguments to set the tray and it works while the VB app is live but then reverts back once the app closes. My plan was to make a "Shell" call from VBA to set the tray position at the start of the macro, then make another "Shell" call to set it back at the end of the print job. I was planning for the VB app to run and close as any other command during the progress through the macro but if the settings are only temporary in the VB app, it won't work. Does anyone have any advice for "permanently" setting the local printer tray selection through VB 8 or VBA? I'm just getting started on the ..NET platform, coming off of VB 6.0. Thanks much. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printer Paper Source Setup
Maybe this:
http://pubs.logicalexpressions.com/p...cle.asp?ID=101 NickHK "RLang" wrote in message ... Hi, I've gathered through some searching that there's no simple method in VBA to set the desired printer tray programatically prior to printing a job through a macro, then setting the printer back to it's default tray. I tried building a VB (Visual Studio 2005) app separately allowing command line arguments to set the tray and it works while the VB app is live but then reverts back once the app closes. My plan was to make a "Shell" call from VBA to set the tray position at the start of the macro, then make another "Shell" call to set it back at the end of the print job. I was planning for the VB app to run and close as any other command during the progress through the macro but if the settings are only temporary in the VB app, it won't work. Does anyone have any advice for "permanently" setting the local printer tray selection through VB 8 or VBA? I'm just getting started on the .NET platform, coming off of VB 6.0. Thanks much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printer paper will not advance | Excel Discussion (Misc queries) | |||
How to change the printer paper source for all worksheets in a wrk | Excel Discussion (Misc queries) | |||
How do I set Printer Paper Source using Visual Basic? | Excel Programming | |||
How do I set Printer Paper Source using Visual Basic? | Excel Programming | |||
Setting printer paper | Excel Programming |