Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel zoom
Message
 
 
À
20/12/2005 09:38:46
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
01079521
Message ID:
01079525
Vues:
16
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform