How to I set the Zoom Property of a work*** to False.

From: Tom Groszko (newscorrespondent_at_charter.net)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 12:03:39 -0500

I am trying to set the Zoom property of a workwheet to false and the
FitToPagesWide = 1.

When I do this from EXCEL and record a macro the generated code is:

.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1

When I put this in my C++ application I have coded:

COleVariant PageZOOM;
PageZOOM = (short)0;
ThisPage.SetZoom (PageZOOM);
COleVariant PagesWide;
PagesWide = (long)1;
ThisPage.SetFitToPagesWide (PagesWide);
ThisPage.SetFitToPagesTall (PagesWide);

I get a dialog box from EXCEL "Unable to set the Zoom property of the
PageSetup class"
How do I set the ZOOM attribute to false from my C++ Application?

Thanks
Tom G.

Loading