COM/OLE Excel

I will pay money for the correct solution. See below.

I'm creating a program that automatically opens a workbook and manipulates some cells in the sheet. However, I'm having a problem with "Range" and "IRange."

I'm using Excel 2000; hence, I'm #importing EXCEL9.OLB. I'm using Win32 API -- no MFC or ATL. I CoCreateInstance(...) an _Application object. I successfully get the Workbooks, _Workbook, Sheets, and _Worksheet.

Using OLE/COM Object Viewer, Range is a dispinterface. IRange is found to be in the interface as well.

The method to obtain a specific range within a _Worksheet is get_Range(VARIANT Cell1, VARIANT Cell2, Range **RHS). Therefore, I have the following...