OLE pagesetup

[Former Member]

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

or

Zomm = integer

but integer <> 0 off course

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

Regards,

[Former Member]

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

or

Zomm = integer

but integer <> 0 off course

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

Regards,

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi antbe,

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

Thanks a lot.

Audrey

[former_member351353]

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