Hi,
I have to write an application in vc++ which will be processing exce
files. I already know how to put something in specific cell but I hav
no idea how to change a color of the cell. Do you know how to do this
Thanks for any tips and advices. Below I paste piece of code which
use to put somthing in the cell A1.

_Application objApp;
_Workbook objBook;
Workbooks objBooks;
Worksheets objSheets;
_Worksheet objSheet;
Range range;
COleVariant VOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);

objBooks = objApp.GetWorkbooks();
objBook = objBooks.Add(VOptional);
objSheets = objBook.GetWorksheets();
objSheet = objSheets.GetItem(COleVariant((short)1));

range = objSheet.GetRange(COleVariant("A1"),COleVariant("A 1"));
range.SetValue(COleVariant("aaa"))

--
vavshe
-----------------------------------------------------------------------
vavshek's Profile: http://www.excelforum.com/member.php...fo&userid=1651
View this thread: http://www.excelforum.com/showthread.php?threadid=31372