I know that the page setup options are specific to the printer, but I
was wondering if there is anyway to access them from VBA.

I regullarly need to overide my companies default "print duplex" option
to print single sided. To do this I have to manually go through each
worksheet and change the page setup options. It would be fantastic if I
could access these options via VBA and write a script to automatically
do it ...

Any ideas, or am I as likely to find an answer as George Bush is to
find a brain cell?


--
CFD


------------------------------------------------------------------------
CFD's Profile: http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=507939

you only can with very complex api calls.
(way over George's head I'd think :)

the nobrainer workaround:
in control panel create a second printer with duplex enabled
and refer to that in your printout code.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


CFD wrote :


I know that the page setup options are specific to the printer, but I
was wondering if there is anyway to access them from VBA.

I regullarly need to overide my companies default "print duplex"
option to print single sided. To do this I have to manually go
through each worksheet and change the page setup options. It would be
fantastic if I could access these options via VBA and write a script
to automatically do it ...

Any ideas, or am I as likely to find an answer as George Bush is to
find a brain cell?

keepITcool Wrote:
you only can with very complex api calls.
(way over George's head I'd think :)

the nobrainer workaround:
in control panel create a second printer with duplex enabled
and refer to that in your printout code.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam
...
Yeah I figured it might have to be API calls ... Oh well, can't
do the work around either as the default print setting is actually
contained on the print server, which will override your own "printer"
settings. The only way I can print single sided is to force the print
server to ignore its default by setting it in excel.


--
CFD


------------------------------------------------------------------------
CFD's Profile: http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=507939

This is for Word, but it should get you started:

http://support.microsoft.com/default...b;en-us;230743
HOWTO: Set Duplex Printing for Word Automation

Also, here is some general information on the printer API from an Access
Perspective:
http://tinyurl.com/4khvy



--
Regards,
Tom Ogilvy


"CFD" wrote in message
...

keepITcool Wrote:
you only can with very complex api calls.
(way over George's head I'd think :)

the nobrainer workaround:
in control panel create a second printer with duplex enabled
and refer to that in your printout code.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam
...
Yeah I figured it might have to be API calls ... Oh well, can't
do the work around either as the default print setting is actually
contained on the print server, which will override your own "printer"
settings. The only way I can print single sided is to force the print
server to ignore its default by setting it in excel.


--
CFD


------------------------------------------------------------------------
CFD's Profile:
http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=507939

Hi

There are loads of page setup parameters that can be set in VBA
If you start a macro recording on a new workbook, select PageSetup from the
File menu, change one of the settings, stop the macro recording.
Then look at the code.

Dave.

"CFD" wrote in message
...

I know that the page setup options are specific to the printer, but I
was wondering if there is anyway to access them from VBA.

I regullarly need to overide my companies default "print duplex" option
to print single sided. To do this I have to manually go through each
worksheet and change the page setup options. It would be fantastic if I
could access these options via VBA and write a script to automatically
do it ...

Any ideas, or am I as likely to find an answer as George Bush is to
find a brain cell?


--
CFD


------------------------------------------------------------------------
CFD's Profile:
http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=507939

Duplex or non-duplex printing isn't one of them.

--
Regards,
Tom Ogilvy


"Dave" wrote in message
...
Hi

There are loads of page setup parameters that can be set in VBA
If you start a macro recording on a new workbook, select PageSetup from
the
File menu, change one of the settings, stop the macro recording.
Then look at the code.

Dave.

"CFD" wrote in message
...

I know that the page setup options are specific to the printer, but I
was wondering if there is anyway to access them from VBA.

I regullarly need to overide my companies default "print duplex" option
to print single sided. To do this I have to manually go through each
worksheet and change the page setup options. It would be fantastic if I
could access these options via VBA and write a script to automatically
do it ...

Any ideas, or am I as likely to find an answer as George Bush is to
find a brain cell?


--
CFD


------------------------------------------------------------------------
CFD's Profile:
http://www.excelforum.com/member.php...o&userid=27306
View this thread:
http://www.excelforum.com/showthread...hreadid=507939