topic Re: OLE pagesetup in Application Development and Automation Discussions

OLE pagesetup

Former Member — Thu, 26 Mar 2009 10:42:14 GMT

Hi experts,

I need to make a preview of an OLE excel.

I would like to set the following properties :

set property of print 'Zoom' = 'False'.
set property of print 'FitToPagesWide' = 1.
set property of print 'FitToPagesTall' = 1.

-> I need to put Zoom to false to excecute the FitToPage properties.

But it doesn't work because OLE don't translate the "False" value.

My biggest problem is that I can't put 0 in place of 'False' because Zoom excpect integer value and bug when the value is 0.

The excel macro only takes

Zoom = False

Zomm = integer

but integer <> 0 off course

If you have any idea to desactivate the "Zoom" property.

Regards,

Re: OLE pagesetup

Former Member — Mon, 20 Apr 2009 11:17:22 GMT

Hi antbe,

My english is bad...

I have the same problem like you.

Do you have a solution ?

If I find a solution, I will send it to you.

Thank you in advance.

Re: OLE pagesetup

Former Member — Wed, 22 Apr 2009 18:58:02 GMT

I have calculated the zoom with the total of an excel sheet and have made some % of that

Tell me if you want more details

Re: OLE pagesetup

Former Member — Wed, 29 Apr 2009 13:10:04 GMT

Hi antbe,

It's a good idea ! I have programing this solution.

Thanks a lot.

Audrey

Re: OLE pagesetup

former_member351353 — Fri, 30 Jul 2010 14:24:04 GMT

audrey - Did you solve this problem. I have the same requirement. I have to set up the Fit to Radio button in print preview. Can you tell me how you did it? If you give the sample code that helps me a lot.

Thanka

kishore