How to get all the sheetname in Excel via COM?

[winniewang11]

Hi everyone,

Could you please tell me how to get all the sheet name in the Excel via COM? Following is the code snippet of C++, I can get the count of all the excel sheet in the excel, But I can't get the name of sheet.... Could you please take a look at it?

Code snippet:

Please Login or Register  to view this content.

Thanks^_^
Winnie

[pankajkaushik12]

Please Login or Register  to view this content.

[royUK]

Private Sub CommandButton1_Click()
MsgBox "the count of workbook is=" & Worksheets.Count

For i = 1 To Worksheets.Count
Cells(i, 1) = Worksheets(i).Name
Next i
End Sub

Please read the Forum Rules & use Code Tags when appropriate.

I don't think the OP is looking for a VBA solution.

[winniewang11]

Thanks a lot to ALL of you^_^
I have found the solution for that, please refer to the code below:

for(int i=1; i<=iSheetCount; i++)
{
lpDisph = m_ExcelSheets.GetItem(COleVariant((long)i));
m_ExcelSheet.AttachDispatch(lpDisph);
CString str = m_ExcelSheet.GetName();
m_ExcelApp.SetDisplayAlerts(TRUE);
i=iSheetCount;
}
}

Because I have to use C++ to complete it. And I didn't find too much sample about it......

Thanks
Winnie