Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BackColor of the cell of EXCEL sheet.
Message
From
20/11/1998 14:18:57
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00159446
Message ID:
00159893
Views:
25
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform