RE: FILL COLOR TO EXCEL PROGRAMMATICALLY

Hi David

Try the following code, it will create a excel object and fill the background color of ten cells

LOCAL oExcel as "Excel.application" 

* create an instance of excel and make it visible
oExcel = CREATEOBJECT("Excel.application")
oExcel.visible = .t.

* add a new workbook  and select the first sheet
oExcel.Workbooks.Add 
oExcel.Sheets(1).select

* set the interior color with the index fromm i 
FOR i = 1 TO 10
	oExcel.Cells(i, 3).Interior.ColorIndex  = i
next

* after filling all cells quit the application
* here we get a message because excel has not saved the file
oExcel.quit 

Best Regards

Vince