change Excel Cell forecolor using VB6

L

Lennie

Hi there,

I am exporting data from ACCESS database to EXCEL Spreadsheet. If the Sales
value is below certain value, I like to forecolor for a specific row to be
RED in color.

Tried using this code in VB6 and it's not working:
objWorksheet.Cells(intRow, intCol).Fill.SchemeColor = vbcolor
 
Top