Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set color in Excel
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP1
Miscellaneous
Thread ID:
00955308
Message ID:
00955333
Views:
19
This message has been marked as the solution to the initial question of the thread.
the sintaxis is somthing like this:

oxlsheet.range("A1:K1").interior.ColorIndex = 6
oxlsheet.range("A1:K1").FONT.ColorIndex = 3

the number for yellow i think is 6

to find out simple go to excel
start the macro recorder
chenge the coloe os a cell
stop the recorder and look at the code that it created.

Bernardo


>My application creates an Excel file. I need to make the 1st row of information in the Excel file appear yellow. I tried the following (for each cell):
>
> oleApp.cells(1,1).BackColor=65535
>
>..and a few other things that are clearly incorrect.
>
>Any help is greatly appreciated.
>
>Martha
B.D.H.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform