change Excel Cell forecolor using VB6
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
|