Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BackColor of the cell of EXCEL sheet.
Message
 
To
19/11/1998 14:41:22
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00159446
Message ID:
00159881
Views:
25
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

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform