Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BackColor of the cell of EXCEL sheet.
Message
De
20/11/1998 14:18:57
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00159446
Message ID:
00159893
Vues:
26
Hi Ken !
Thanks.
I am happy ;)
Where it is possible to look complete hierarchy of objects?
Denis.

>Hi Denis!
>
>Use the ColorIndex and Color properties of the Range.Selection.Interior:
>
>
#define xlNone -4142
>
>oXL=createobj('excel.application')
>oXL.visible=.t.
>
>with oXL
>    .Workbooks.Add
>    .Range("A1:E12").Select
>    With .Selection.Interior
>         .ColorIndex = xlNone
>         .Color = rgb(128,0,0)
>    EndWith
>    .Range("C6").Select
>endwith
>
>>Hi.
>>How I can change colour of the cell of Excel sheet?
>>I can not find in Help and ObjectBrowser suitable property for Range object :((.
>>Thanks
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform