Working with Excel worksheets.

Hi



to work with excel files see



Working with Excel via COM for



more details



To work with fonts and colors in excel refer following links

[url= http://msdn.microsoft.com/en-us/library/cc296089%28v=office.12%29.aspx] http://msdn.microsoft.com/en-us/library/cc296089%28v=office.12%29.aspx[/url]



Sample to set font color



 Set app = Sys.OleObject("Excel.Application")

 app.DisplayAlerts = False

 Set book = app.Workbooks.Open(filepath)

Set sheet1 = book.Sheets(sheetname)



Sheet1.Cells(Row, Column)).Font.ColorIndex=1



  book.Save    

app.Workbooks.Close

app.Quit