Accessing Page Setup Options from VBA
 

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

Accessing Page Setup Options from VBA
 

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?

Accessing Page Setup Options from VBA
 

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 ... :mad: 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

Accessing Page Setup Options from VBA
 

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 ... :mad: 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

Accessing Page Setup Options from VBA
 

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

Accessing Page Setup Options from VBA
 

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