Click here to Skip to main content
15,565,183 members
Home / Discussions / COM
   

COM

 
GeneralRe: Get Events from an COM Server Pin
Stuart Dootson5-Oct-09 5:19
professionalStuart Dootson5-Oct-09 5:19 
GeneralRe: Get Events from an COM Server Pin
Juergen_808-Oct-09 3:36
Juergen_808-Oct-09 3:36 
GeneralRe: Get Events from an COM Server Pin
Stuart Dootson8-Oct-09 8:44
professionalStuart Dootson8-Oct-09 8:44 
AnswerRe: Get Events from an COM Server Pin
Juergen_802-Nov-09 3:49
Juergen_802-Nov-09 3:49 
QuestionHow to update DOM in IE by using IHTMLDocument , and IHTMLElement Pin
am 20091-Oct-09 8:17
am 20091-Oct-09 8:17 
QuestionGetting Excel sheet names Pin
gtag1-Oct-09 2:01
gtag1-Oct-09 2:01 
AnswerRe: Getting Excel sheet names Pin
Stuart Dootson1-Oct-09 23:16
professionalStuart Dootson1-Oct-09 23:16 
GeneralRe: Getting Excel sheet names [modified] Pin
gtag2-Oct-09 7:17
gtag2-Oct-09 7:17 
Hi Stuart,

Thanks again.

But I am not getting name its failing at getting sheets from the workbook to which I am pointing.

Main aim is to get the workbook names and worksheets names opened by the user, might be 50 workbooks or any number.

Please check the code and let me know where I am doing wrong?

//MicroSoft Office Objects
#import \
"C:\Program Files\Common Files\Microsoft Shared\OFFICE11\mso.dll" \
rename("DocumentProperties", "DocumentPropertiesXL") \
rename("RGB", "RBGXL")

//Microsoft VBA Objects
#import \
"C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\vbe6ext.olb"


using namespace Office;
//Excel Application Objects
#import "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" \
rename("DialogBox", "DialogBoxXL") rename("RGB", "RBGXL") \
rename("DocumentProperties", "DocumentPropertiesXL") \
rename("ReplaceText", "ReplaceTextXL") \
rename("CopyFile", "CopyFileXL") \
exclude("IFont", "IPicture") no_dual_interfaces

using namespace std;
#include <string>
int _tmain()
{
     Excel::_ApplicationPtr XL;
     Excel::WorkbooksPtr book;
     Excel::WorksheetsPtr sheet;
    

     string BookName;
     string SheetName;
    
     int BookCount;
     int SheetCount;
     string bookArray[20];
     int count;
//A try block is used to trap any errors in communication
try
{
//Initialise COM interface
CoInitialize(NULL);

HRESULT hr = XL.GetActiveObject(L"Excel.Application");
if(SUCCEEDED(hr))
{
     book = XL->Workbooks;
     BookCount = book->Count;

     for(int i=1;i<=BookCount;i++)
     {
     BookName = book->Item[i]->Name;
     cout<<BookName<<endl;
     SheetCount = book->Item[i]->Sheets->Count;
     for(int j=1;j<SheetCount;j++)
     {
          sheet = book->Item[i]->GetWorksheets();
          if(sheet)
          {
               Excel::_WorksheetPtr pSheet = sheet->Item[j];
               SheetName = pSheet->Name;
               cout<<SheetName<<endl;
          }
     }
     }
}
}
catch(_com_error &error)
{
     //cout << "COM error " << endl;

}
}

gtag

modified on Friday, October 2, 2009 12:24 PM

GeneralRe: Getting Excel sheet names Pin
Stuart Dootson2-Oct-09 9:59
professionalStuart Dootson2-Oct-09 9:59 
GeneralRe: Getting Excel sheet names Pin
gtag3-Oct-09 0:53
gtag3-Oct-09 0:53 
GeneralRe: Getting Excel sheet names Pin
Stuart Dootson3-Oct-09 1:11
professionalStuart Dootson3-Oct-09 1:11 
GeneralRe: Getting Excel sheet names Pin
Richard MacCutchan3-Oct-09 1:39
mveRichard MacCutchan3-Oct-09 1:39 
GeneralRe: Getting Excel sheet names Pin
gtag3-Oct-09 1:43
gtag3-Oct-09 1:43 
GeneralRe: Getting Excel sheet names Pin
gtag12-Nov-09 19:31
gtag12-Nov-09 19:31 
QuestionCall an COM Server dispinterface C++ Pin
Juergen_8030-Sep-09 5:58
Juergen_8030-Sep-09 5:58 
AnswerRe: Call an COM Server dispinterface C++ Pin
Juergen_801-Oct-09 22:14
Juergen_801-Oct-09 22:14 
AnswerRe: Call an COM Server dispinterface C++ Pin
Stuart Dootson1-Oct-09 23:03
professionalStuart Dootson1-Oct-09 23:03 
QuestionWMP SDK 11 audio and video file DRM and attribute querying Pin
Barney Wray29-Sep-09 6:17
Barney Wray29-Sep-09 6:17 
QuestionIShellLinkW getArguments gives some strange symbols instead of the shortcuts' arguments Pin
coderomega26-Sep-09 12:26
coderomega26-Sep-09 12:26 
Questionhow to use an interface belong to another library in idl file Pin
samfromcn26-Sep-09 2:26
samfromcn26-Sep-09 2:26 
AnswerRe: how to use an interface belong to another library in idl file Pin
«_Superman_»26-Sep-09 7:49
professional«_Superman_»26-Sep-09 7:49 
GeneralRe: how to use an interface belong to another library in idl file [modified] Pin
samfromcn26-Sep-09 16:50
samfromcn26-Sep-09 16:50 
AnswerRe: how to use an interface belong to another library in idl file Pin
Vi228-Sep-09 21:14
Vi228-Sep-09 21:14 
QuestionMake Extra Cash At Home Pin
aqasim25-Sep-09 2:21
aqasim25-Sep-09 2:21 
AnswerRe: Make Extra Cash At Home Pin
Stuart Dootson25-Sep-09 3:38
professionalStuart Dootson25-Sep-09 3:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.