Hi Nagesh PV,
You can have an idea of changing cell interior/ font colors in excell sheet from the following code.
Try this and let us know how it worked for you.
Rekha
You can have an idea of changing cell interior/ font colors in excell sheet from the following code.
Code:
Set xl=createobject ("excel.application")
set xls=xl.workbooks.add
For i=0 to 54
xls.sheets(3).cells(i,1)=i
xls.sheets(3).cells(i,1).interior.colorindex=i
xls.sheets(3).cells(i,1).Font.colorindex=i+20
Next
xls.saveas""C:\Documents and Settings\rekha\Desktop\Colors.xls""
xls.quit
xl.quit
xls=nothing
xl=nothingTry this and let us know how it worked for you.
Rekha