After struggling a little bit, now I am able to write a program to access excel spreadsheets using MFC in VS2005. I am able to create the wrapper and able to access excel files, write data into it by specifying a cell number manually.

Also I can search for data in a given range by using Range.Find() function.

#define vOpt COleVariant((long) DISP_E_PARAMNOTFOUND, VT_ERROR)
Range range;
if(range.Find(COleVariant("09/28"), vOpt, vOpt, vOpt, vOpt, (long) 1, vOpt, vOpt))
Can someone please tell me how to get the cell number of that specific cell where the data is located.

Also is there any good tutorial or help file where I can refer to for further questions.

Thanks in advance