Re: Accessing Page Setup Options from VBA

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <CFD.22mloz_1138923901.8813@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CFD.22mloz_1138923901.8813@xxxxxxxxxxxxxxxxxxxxxxxx

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
work*** 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?action=getinfo&userid=27306
View this thread: http://www.excelforum.com/showthread.php?threadid=507939



.

Quantcast