Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel cell backround color....
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Excel cell backround color....
Miscellaneous
Thread ID:
00887668
Message ID:
00887675
Views:
7
Do you mean, this?
ObjExcel.ActiveSheet.Range("a2").Interior.ColorIndex = 46
The syntax may vary however for various Excel versions. The common advise is to record a macro in Excel and then convert code from there to VFP.

>Hey,
>
>How do I change the backround color of a cell using OLE?
>
>Does anyone have a good reference site for OLE and Excel besides MSDN?
>
>Thanks!
Previous
Reply
Map
View

Click here to load this message in the networking platform