Click here to Skip to main content
15,566,520 members
Home / Discussions / COM
   

COM

 
GeneralRe: Get Events from an COM Server Pin
Stuart Dootson5-Oct-09 1:15
professionalStuart Dootson5-Oct-09 1:15 
GeneralRe: Get Events from an COM Server Pin
Juergen_805-Oct-09 5:05
Juergen_805-Oct-09 5:05 
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 
Hi,

I am using following imports:

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

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

//Excel Application Objects

using namespace Office;

#import "C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE"\
      rename("DialogBox", "DialogBoxXL") rename("RGB", "RBGXL")\
      rename("DocumentProperties", "DocumentPropertiesXL")\
      rename("ReplaceText", "ReplaceTextXL")\
      rename("CopyFile", "CopyFileXL")\
      exclude("IFont", "IPicture") no_dual_interfaces


Excel::_ApplicationPtr XL;
Excel::_WorkbookPtr book;
Excel::_WorksheetPtr sheet;

By using for loop ,able to get all workbook names.Using following code iterating through item, getting all workbook names.

book = XL->Workbooks->Item[1];

In case of worksheet, i am not getting the name of worksheet.There is no such option as workbook.

Able to point to particular sheet, but name option is not there.
sheet = XL->Workbooks->Item[1]->Sheets->Item[1];

I want to retrieve whole list of worksheets present in workbook.

Googled but I didn't get any clue.

If there is any option, please give me clue.

Thanks in advance.

Gtag.
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 
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 

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.