Click here to Skip to main content
15,391,859 members
Home / Discussions / COM
   

COM

 
QuestionTLDR, simpler version Pin
T800G18-Apr-13 10:23
MemberT800G18-Apr-13 10:23 
QuestionHow to get the path Pin
sarfaraznawaz27-Feb-13 19:44
Membersarfaraznawaz27-Feb-13 19:44 
AnswerRe: How to get the path Pin
Richard MacCutchan27-Feb-13 22:04
mveRichard MacCutchan27-Feb-13 22:04 
GeneralRe: How to get the path Pin
sarfaraznawaz27-Feb-13 22:27
Membersarfaraznawaz27-Feb-13 22:27 
GeneralRe: How to get the path Pin
Richard MacCutchan27-Feb-13 22:46
mveRichard MacCutchan27-Feb-13 22:46 
GeneralRe: How to get the path Pin
sarfaraznawaz27-Feb-13 23:27
Membersarfaraznawaz27-Feb-13 23:27 
GeneralRe: How to get the path Pin
Richard MacCutchan27-Feb-13 23:28
mveRichard MacCutchan27-Feb-13 23:28 
QuestionWorkBooks::OpenText file not loading Pin
ForNow12-Feb-13 10:38
MemberForNow12-Feb-13 10:38 
Hi,

I have the following code sequences whose pourpose is to display a .txt file in a Excel Spreadsheet, however the .txt file is not being loaded after I execute workbooks.opentext
a workbook is loaded but there are no sheets displayed let alone text
I get good return codes from IDispatch->invoke and good return codes in excpInfo

I have changed the file name to a bogous name and the same thing happens


C++
  app.CreateDispatch("Excel.Application");  // this works my code I usally check AX register    
  Workbooks objBooks(app.Workbooks());       // while testing
 
 Workbooks objBooks = app.GetWorkbooks();
 
    COleVariant FilenameOpen(File), 
        FilenameSave(XlsFile), 
        Origin((short)2), // xlWindows 
        StartRow((short)1), 
        DataType((short)1), // xlDelimited 
        TextQualifier((short)1), // xlDoubleQuote 
        ConsecutiveDelimiter((long)FALSE, VT_BOOL), 
        Tab((long)FALSE, VT_BOOL), 
        Semicolon((long)TRUE, VT_BOOL),
		Comma((long)FALSE, VT_BOOL), 
		Space((long)FALSE, VT_BOOL),
		Other((long)FALSE, VT_BOOL),
		Otherchar((long)FALSE,VT_BOOL),
		Fieldinfo((long) FALSE, VT_BOOL),
		TextVisualLayout((long)FALSE, VT_BOOL),
		DecimalSeperator((long) FALSE, VT_BOOL),
		ThousandSepartor((long) FALSE, VT_BOOL),
		TrailingMinusNumbers((long) FALSE, VT_BOOL),
		Local((long) FALSE, VT_BOOL),
                  Fileformat((short)33), // xlExcel4 
                  Save((long)FALSE, VT_BOOL);

COleSafeArray saRet;
DWORD numElements[2];
numElements[0] = 2;
numElements[1] = 2;
saRet.Create(VT_I4,2,numElements);
long index[2];
long val;
index[0]=0;
index[1]=0;
val = 1;
saRet.PutElement(index,&val);
index[0] = 1;
index[1] = 0;
val = 2;
index[0] = 1;
index[1] = 1;
val = 9;

objBooks.OpenText((LPCTSTR)"C:\\Program Files\\Microsoft VIsual Studio\\MyProjects\\I46023\\I46023.txt", Origin, COleVariant((long)1),COleVariant((long)1),  
             1, 
			 ConsecutiveDelimiter, Tab, Semicolon,
 			 Comma,Space,Other,Otherchar,saRet,TextVisualLayout,
 			 DecimalSeperator,ThousandSepartor,TrailingMinusNumbers,
 			 Local);
			
 app.SetVisible(true);
  app.SetUserControl(TRUE);
















AnswerRe: WorkBooks::OpenText file not loading Pin
Richard MacCutchan27-Feb-13 22:09
mveRichard MacCutchan27-Feb-13 22:09 
GeneralRe: WorkBooks::OpenText file not loading Pin
ForNow28-Feb-13 8:07
MemberForNow28-Feb-13 8:07 
GeneralRe: WorkBooks::OpenText file not loading Pin
Richard MacCutchan28-Feb-13 21:47
mveRichard MacCutchan28-Feb-13 21:47 
GeneralRe: WorkBooks::OpenText file not loading Pin
ForNow1-Mar-13 8:20
MemberForNow1-Mar-13 8:20 
GeneralRe: WorkBooks::OpenText file not loading Pin
Richard MacCutchan1-Mar-13 23:46
mveRichard MacCutchan1-Mar-13 23:46 
QuestionDISP_E_EXCEPTION & excepinfo->scode 800A03EC from WorkBooks::OpenText Pin
ForNow6-Feb-13 12:26
MemberForNow6-Feb-13 12:26 
AnswerRe: DISP_E_EXCEPTION & excepinfo->scode 800A03EC from WorkBooks::OpenText Pin
Richard MacCutchan6-Feb-13 22:34
mveRichard MacCutchan6-Feb-13 22:34 
QuestionWorkBooks::OpenText failure Pin
ForNow5-Feb-13 11:25
MemberForNow5-Feb-13 11:25 
AnswerRe: WorkBooks::OpenText failure Pin
Garth J Lancaster5-Feb-13 14:47
professionalGarth J Lancaster5-Feb-13 14:47 
QuestionDISP_E_UNKNOWNNAME from GetIDsOfNames Pin
ForNow29-Jan-13 14:04
MemberForNow29-Jan-13 14:04 
AnswerRe: DISP_E_UNKNOWNNAME from GetIDsOfNames Pin
Richard MacCutchan29-Jan-13 21:16
mveRichard MacCutchan29-Jan-13 21:16 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames Pin
ForNow30-Jan-13 8:36
MemberForNow30-Jan-13 8:36 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames Pin
Richard MacCutchan30-Jan-13 9:35
mveRichard MacCutchan30-Jan-13 9:35 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames Pin
Richard MacCutchan30-Jan-13 9:39
mveRichard MacCutchan30-Jan-13 9:39 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames Pin
ForNow30-Jan-13 9:58
MemberForNow30-Jan-13 9:58 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames Pin
Richard MacCutchan30-Jan-13 10:10
mveRichard MacCutchan30-Jan-13 10:10 
GeneralFound the Answer PLease Read Pin
ForNow30-Jan-13 10:34
MemberForNow30-Jan-13 10:34 

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.