Click here to Skip to main content
15,878,543 members
Home / Discussions / COM
   

COM

 
GeneralRe: Get Events from an COM Server Pin
Juergen_808-Oct-09 2:36
Juergen_808-Oct-09 2:36 
GeneralRe: Get Events from an COM Server Pin
Stuart Dootson8-Oct-09 7:44
professionalStuart Dootson8-Oct-09 7:44 
AnswerRe: Get Events from an COM Server Pin
Juergen_802-Nov-09 2:49
Juergen_802-Nov-09 2:49 
QuestionHow to update DOM in IE by using IHTMLDocument , and IHTMLElement Pin
am 20091-Oct-09 7:17
am 20091-Oct-09 7:17 
QuestionGetting Excel sheet names Pin
gtag1-Oct-09 1:01
gtag1-Oct-09 1:01 
AnswerRe: Getting Excel sheet names Pin
Stuart Dootson1-Oct-09 22:16
professionalStuart Dootson1-Oct-09 22:16 
GeneralRe: Getting Excel sheet names [modified] Pin
gtag2-Oct-09 6:17
gtag2-Oct-09 6:17 
GeneralRe: Getting Excel sheet names Pin
Stuart Dootson2-Oct-09 8:59
professionalStuart Dootson2-Oct-09 8:59 
gtag wrote:
     Excel::WorksheetsPtr sheet;


Should be Excel::SheetsPtr sheet;

gtag wrote:
               Excel::_WorksheetPtr pSheet = sheet->Item[j];


Not all sheets are worksheets. This line can raise an exception as well if, for example, you have a chart sheet. So, you should use this code:

sheet = book->Item[i]->Sheets;
if(sheet)
{
     try {
        Excel::_WorksheetPtr pSheet = sheet->Item[j];
        SheetName = pSheet->Name;
        cout<<SheetName<<endl;
     }
     catch (_com_error&) { cout << "Sheet "  << j << " is not a worksheet\n"; }
}


Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

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

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.