Excel: how to zoom current worksheet on screen 1

[msc0tt]

My app (VB6) dynamically builds a report in Excel. One of the requirements is setting the viewing zoom to 75%. There appears to be a .Zoom property of the ActiveSheet, but it errors out when assigning 75 to it. My research so far has only turned up examples of the .PageSetup.Zoom property, which DOES accept a value such as 75.

As a more general question, where can a find a complete online reference to the Excel 9 Object Model? (MSDN searches bring up many examples, but NOT the entire model).
-with thanks

 

[Swi]

Try something like this:

ActiveWindow.Zoom = 75


Swi

 

[msc0tt]

We gotta Bingo - Thanks!

(man, 30 minutes of Goggling and nothing! Post on TekTips, and 2 minutes later, success!)

 

[Swi]

When I do not know the exact syntax for something in Excel I just record a macro and paste it into my VB code. Most of it translates without any problems.

Swi

 

[msc0tt]

Swi,
What a damm good idea. You have just saved me TONS of future hassle with the Excel Object! Many thanks!!
-Mike