Adjust page setup margins via a macro

[lstephane]

Hi,

I have a template report that I need to automate but I want to adjust margins to elimitate all trailling spaces on the right-end side as well that the ones at the bottom.

Can somebody knows how I can dynamically adjust the page margins via a macro so i can make my report the best great looking as possible ?

Thanks !


Stéphane Lambert, Analyst/Programmer - BI Specialist
Info Quest (IQ), Data Warehouse System
McKesson Canada Corporation

EMail: stephane.lambert@mckesson.ca

 

[lstephane]

Additional Info: The report is a PowerPlay Client Reporter.

Stéphane Lambert, Analyst/Programmer - BI Specialist
Info Quest (IQ), Data Warehouse System
McKesson Canada Corporation

EMail: stephane.lambert@mckesson.ca

 

[drlex]

Stéphane,
I found the formatting commands available in PowerPlay to be non-existent, so do all my reformatting in Excel. Is it possible for you to have a selection of templates to cover the likely values in the report, rather than change one?

soi la, soi carré