Excel Zoom property

[Gatet]

Hola amigos!

I´m trying to set the zoom value of a excel worksheet without success. I cannot either edit manually the value nor get it with constants (see figure). Can somebody give me a hand?

Gracias!

[Jonnie_5]

Your example should work using the numeric constant for the zoom variant (75).  Remember that this Zoom property controls the print zoom, not the on-screen (monitor) view zoom (e.g. the 100% view drop down menu in the excel app).  To see the effect, either print the sheet or do a print preview.  For more, right click the PageSetup.Zoom property node and see the Zoom property help.

!Buena suerte!

[Gatet]

Hi, Jonnie!

Ok, so I´m in the wrong direction, cause my intention is to set the zoom in the excelsheet directly, cause I´m using many fields and they are "hidden" to the user. Anyway, it´s not working (see the result in the probe, the quotation marks shouldn´t be there...)

[Jonnie_5]

Right - you want to use the Window.Zoom property.

Set it up with an _Application.ActiveWindow Property Node, wiring this value to a Window.Zoom property node.

LV 7 & jpeg attached.