Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BackColor of the cell of EXCEL sheet.
Message
 
À
19/11/1998 14:41:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00159446
Message ID:
00159881
Vues:
26
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
kenweber
GCom2 Solutions
Microsoft Certified Professional

Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform