Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Horizontal Alignment in Excel?
Message
De
14/07/2009 19:27:02
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
14/07/2009 19:19:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Versions des environnements
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Divers
Thread ID:
01412369
Message ID:
01412374
Vues:
55
>It looks like...
>
>Sub Macro1()
>'
>' Macro1 Macro
>' Macro recorded 7/14/2009 by Martha Kroll
>'
>
>'
> With Selection
> .HorizontalAlignment = xlLeft
> .VerticalAlignment = xlBottom
> .WrapText = False
> .Orientation = 0
> .AddIndent = False
> .IndentLevel = 0
> .ShrinkToFit = False
> .ReadingOrder = xlContext
> .MergeCells = False
> End With
>End Sub

If you have some object that refers to a worksheet, the relevant part would be, in VFP:
loSheet(lnRow, lnCol).HorizontalAlignment = xlLeft
xlLeft is a constant understood by VBA, but not (initially) by Visual FoxPro. It is easiest to search in the download section, for "Excel constants", and include the file provided.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform