set color (vc++)

[vavshek]

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("A1"));
range.SetValue(COleVariant("aaa"))

 

[Bob Phillips]

Don't know vc++, but to set a colour, use

range.Interior.Colorindex=35

the number is the colour pallette index number.

--

HTH

RP
(remove nothere from the email address if mailing direct)