As in VB's

MyWorksheet.Cells(2,3) = "Hello1"

If I wanna do this in VC++,
What's the equivalent way(using ATL).

More specifically,
I've downloaded the following code from a Web source.

.............
CoInitialize(NULL);

Excel::_ApplicationPtr excel;
HRESULT hr = excel.CreateInstance(L"Excel.Application");

Excel::_WorkbookPtr workbook =
excel-Workbooks-Add(static_cast<long(Excel::xlWorksheet));
Excel::_WorksheetPtr worksheet = excel-ActiveSheet;

worksheet-Range["A1"]-Value = "Hello1"; // Set a value

workbook-Close();
excel-Quit();
CoUninitialize();
........

In this source code,
How can I change this
worksheet-Range["A1"]-Value = "Hello1";
to the following way
worksheet-Cells ?

Thanks, In advance.

David K. Kim wrote:
In this source code,
How can I change this
worksheet-Range["A1"]-Value = "Hello1";
to the following way
worksheet-Cells ?

Thanks, In advance.


I guess nobody in this Excel newsgroup speaks C++ (including me).
But it would seem reasonable, by analogy, that

worksheet-Cells[2,3]-Value = "Hello1";

might work.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup