Click here to Skip to main content
15,888,802 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: run one system exe on the Another system Pin
Rajesh R Subramanian29-Sep-09 1:54
professionalRajesh R Subramanian29-Sep-09 1:54 
GeneralRe: run one system exe on the Another system Pin
trioum29-Sep-09 2:44
trioum29-Sep-09 2:44 
QuestionPointer to CWnd* - why does not this work? [modified] Pin
Makakuin28-Sep-09 21:23
Makakuin28-Sep-09 21:23 
AnswerRe: Pointer to CWnd* - why does not this work? Pin
Cedric Moonen28-Sep-09 21:50
Cedric Moonen28-Sep-09 21:50 
QuestionRe: Pointer to CWnd* - why does not this work? Pin
CPallini28-Sep-09 22:08
mveCPallini28-Sep-09 22:08 
AnswerRe: Pointer to CWnd* - why does not this work? Pin
Makakuin28-Sep-09 22:09
Makakuin28-Sep-09 22:09 
QuestionHow can i read environment variable from c program [modified] Pin
mohant$.net28-Sep-09 20:08
mohant$.net28-Sep-09 20:08 
AnswerRe: How can i read environment variable from c program Pin
Code-o-mat28-Sep-09 20:25
Code-o-mat28-Sep-09 20:25 
AnswerRe: How can i read environment variable from c program Pin
«_Superman_»28-Sep-09 20:47
professional«_Superman_»28-Sep-09 20:47 
QuestionCListCtrl Pin
john563228-Sep-09 20:01
john563228-Sep-09 20:01 
AnswerRe: CListCtrl Pin
Code-o-mat28-Sep-09 20:22
Code-o-mat28-Sep-09 20:22 
GeneralRe: CListCtrl Pin
john563228-Sep-09 20:25
john563228-Sep-09 20:25 
GeneralRe: CListCtrl Pin
Code-o-mat28-Sep-09 20:37
Code-o-mat28-Sep-09 20:37 
QuestionConstrucor getting called twice........ Pin
hrishiS28-Sep-09 19:31
hrishiS28-Sep-09 19:31 
AnswerRe: Construcor getting called twice........ Pin
Iain Clarke, Warrior Programmer28-Sep-09 19:40
Iain Clarke, Warrior Programmer28-Sep-09 19:40 
AnswerRe: Construcor getting called twice........ Pin
Alan Balkany5-Oct-09 4:40
Alan Balkany5-Oct-09 4:40 
QuestionPassing data in dialog based application (model dialog) Pin
hrishiS28-Sep-09 18:54
hrishiS28-Sep-09 18:54 
AnswerRe: Passing data in dialog based application (model dialog) Pin
Solon_lee28-Sep-09 19:30
Solon_lee28-Sep-09 19:30 
GeneralRe: Passing data in dialog based application (model dialog) Pin
hrishiS28-Sep-09 19:32
hrishiS28-Sep-09 19:32 
AnswerRe: Passing data in dialog based application (model dialog) Pin
Iain Clarke, Warrior Programmer28-Sep-09 19:50
Iain Clarke, Warrior Programmer28-Sep-09 19:50 
GeneralRe: Passing data in dialog based application (model dialog) Pin
hrishiS28-Sep-09 20:12
hrishiS28-Sep-09 20:12 
QuestionHow to get list of worksheet names using VC++ [modified] Pin
gtag28-Sep-09 18:09
gtag28-Sep-09 18: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 18:38
Steve1443-Nov-09 18:38 
QuestionGetDlgItem Pin
voisdnull28-Sep-09 17:08
voisdnull28-Sep-09 17:08 
AnswerRe: GetDlgItem Pin
Rajesh R Subramanian28-Sep-09 18:21
professionalRajesh R Subramanian28-Sep-09 18:21 

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.