Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel zoom
Message
 
 
To
20/12/2005 09:38:46
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
01079521
Message ID:
01079525
Views:
17
What is the value of xlFalse?
        .Zoom = .F.        && Works
        .Zoom = 0          && Error
>I tried to change the zoom factor, to auto-fit on a page. The macro recorder gives me the following commands:
>
>
>    With ActiveSheet.PageSetup
>        ...
>        .Zoom = False
>        .FitToPagesWide = 1
>        .FitToPagesTall = 1
>    End With
>
>
>I omitted lots of options, but the Excel macro still works without them.
>
>I changed this, in VFP, to:
>
>
>    with This.oSheet.PageSetup
>        .Zoom = xlFalse
>        .FitToPagesWide = 1
>        .FitToPagesTall = 1
>    Endwith
>
>However, I get an error message on the line that starts with ".Zoom...", stating that it is impossible to assign property Zoom of the class PageSetup.
>
>Setting a fixed percentage works fine. While it now turns out that this is what the users actually want, I would still like to know how to solve this situation.
>
>TIA,
>
>Hilmar
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform