Click here to Skip to main content
15,559,667 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: Construcor getting called twice........ Pin
Iain Clarke, Warrior Programmer28-Sep-09 20:40
Iain Clarke, Warrior Programmer28-Sep-09 20:40 
AnswerRe: Construcor getting called twice........ Pin
Alan Balkany5-Oct-09 5:40
Alan Balkany5-Oct-09 5:40 
QuestionPassing data in dialog based application (model dialog) Pin
hrishiS28-Sep-09 19:54
hrishiS28-Sep-09 19:54 
AnswerRe: Passing data in dialog based application (model dialog) Pin
Solon_lee28-Sep-09 20:30
Solon_lee28-Sep-09 20:30 
GeneralRe: Passing data in dialog based application (model dialog) Pin
hrishiS28-Sep-09 20:32
hrishiS28-Sep-09 20:32 
AnswerRe: Passing data in dialog based application (model dialog) Pin
Iain Clarke, Warrior Programmer28-Sep-09 20:50
Iain Clarke, Warrior Programmer28-Sep-09 20:50 
GeneralRe: Passing data in dialog based application (model dialog) Pin
hrishiS28-Sep-09 21:12
hrishiS28-Sep-09 21:12 
QuestionHow to get list of worksheet names using VC++ [modified] Pin
gtag28-Sep-09 19:09
gtag28-Sep-09 19:09 
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.

Hey if any one knows, please give me clue.

modified on Tuesday, September 29, 2009 9:29 AM

AnswerRe: How to get list of worksheet names using VC++ Pin
Steve1443-Nov-09 19:38
Steve1443-Nov-09 19:38 
QuestionGetDlgItem Pin
voisdnull28-Sep-09 18:08
voisdnull28-Sep-09 18:08 
AnswerRe: GetDlgItem Pin
Rajesh R Subramanian28-Sep-09 19:21
professionalRajesh R Subramanian28-Sep-09 19:21 
GeneralRe: GetDlgItem Pin
Iain Clarke, Warrior Programmer28-Sep-09 20:52
Iain Clarke, Warrior Programmer28-Sep-09 20:52 
GeneralRe: GetDlgItem Pin
voisdnull29-Sep-09 5:48
voisdnull29-Sep-09 5:48 
GeneralRe: GetDlgItem Pin
Iain Clarke, Warrior Programmer1-Oct-09 2:39
Iain Clarke, Warrior Programmer1-Oct-09 2:39 
GeneralRe: GetDlgItem Pin
voisdnull1-Oct-09 8:34
voisdnull1-Oct-09 8:34 
QuestionBitmaps won't show in splitter pane - only one at the time. Seeking advice how to trobleshoot. Pin
Vaclav_28-Sep-09 16:01
Vaclav_28-Sep-09 16:01 
AnswerRe: Bitmaps won't show in splitter pane - only one at the time. Seeking advice how to trobleshoot. Pin
Richard MacCutchan28-Sep-09 23:27
mveRichard MacCutchan28-Sep-09 23:27 
GeneralRe: Bitmaps won't show in splitter pane - only one at the time. Seeking advice how to trobleshoot. Pin
Vaclav_29-Sep-09 4:48
Vaclav_29-Sep-09 4:48 
QuestionMy project is allways out of date Pin
SNArruda28-Sep-09 10:57
SNArruda28-Sep-09 10:57 
AnswerRe: My project is allways out of date Pin
Rick York28-Sep-09 12:52
mveRick York28-Sep-09 12:52 
QuestionWindows 7 / MAPIResolveName Pin
Steve Thresher28-Sep-09 7:33
Steve Thresher28-Sep-09 7:33 
AnswerRe: Windows 7 / MAPIResolveName Pin
Randor 28-Sep-09 20:45
professional Randor 28-Sep-09 20:45 
GeneralRe: Windows 7 / MAPIResolveName Pin
Steve Thresher28-Sep-09 22:19
Steve Thresher28-Sep-09 22:19 
QuestionAuto update software Pin
includeh1028-Sep-09 6:29
includeh1028-Sep-09 6:29 
AnswerRe: Auto update software Pin
Moak28-Sep-09 7:08
Moak28-Sep-09 7:08 

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.