How to I set the Zoom Property of a worksheet to False.

T

Tom Groszko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top