Hi,
The following generates a list of colorindex values and sets the background to the corresponding color:

o = CREATEOBJECT("excel.application")
o.Workbooks.Add()

FOR i = 1 TO 56
   o.ActiveSheet.cells(i,1).value = i
   o.ActiveSheet.cells(i,1).Interior.ColorIndex = i
ENDFOR &&* i = 1 TO 56

o.visible = .t.

You could also use the color property. The easiest way to explore VBA is to record a macro in Excel and then examine the generated code. VBA makes extensive use of constants. You can use the VBA object browser to get the values of these constants. If you're using VFP7, then you can use VFP's object browser.

HTH
>Hi,
>
>i know that way can put a Single Under Line in Excel
>CELLS(??).Borders(9).LineStyle = 1
>
>how can i put the background color in it ( and the code of COLOR TABLE) ?