Click here to Skip to main content
       

COM

 
QuestionTLDR, simpler version PinmemberT800G18-Apr-13 10:23 
QuestionHow to get the path [modified] Pinmembersarfaraznawaz27-Feb-13 19:44 
AnswerRe: How to get the path PinmvpRichard MacCutchan27-Feb-13 22:04 
GeneralRe: How to get the path Pinmembersarfaraznawaz27-Feb-13 22:27 
GeneralRe: How to get the path PinmvpRichard MacCutchan27-Feb-13 22:46 
GeneralRe: How to get the path Pinmembersarfaraznawaz27-Feb-13 23:27 
GeneralRe: How to get the path PinmvpRichard MacCutchan27-Feb-13 23:28 
QuestionWorkBooks::OpenText file not loading PinmemberForNow12-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
 

  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 PinmvpRichard MacCutchan27-Feb-13 22:09 
GeneralRe: WorkBooks::OpenText file not loading PinmemberForNow28-Feb-13 8:07 
GeneralRe: WorkBooks::OpenText file not loading PinmvpRichard MacCutchan28-Feb-13 21:47 
GeneralRe: WorkBooks::OpenText file not loading PinmemberForNow1-Mar-13 8:20 
GeneralRe: WorkBooks::OpenText file not loading PinmvpRichard MacCutchan1-Mar-13 23:46 
QuestionDISP_E_EXCEPTION & excepinfo->scode 800A03EC from WorkBooks::OpenText PinmemberForNow6-Feb-13 12:26 
AnswerRe: DISP_E_EXCEPTION & excepinfo->scode 800A03EC from WorkBooks::OpenText PinmvpRichard MacCutchan6-Feb-13 22:34 
QuestionWorkBooks::OpenText failure PinmemberForNow5-Feb-13 11:25 
AnswerRe: WorkBooks::OpenText failure PinmemberGarth J Lancaster5-Feb-13 14:47 
QuestionDISP_E_UNKNOWNNAME from GetIDsOfNames PinmemberForNow29-Jan-13 14:04 
AnswerRe: DISP_E_UNKNOWNNAME from GetIDsOfNames PinmvpRichard MacCutchan29-Jan-13 21:16 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames PinmemberForNow30-Jan-13 8:36 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames PinmvpRichard MacCutchan30-Jan-13 9:35 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames PinmvpRichard MacCutchan30-Jan-13 9:39 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames PinmemberForNow30-Jan-13 9:58 
GeneralRe: DISP_E_UNKNOWNNAME from GetIDsOfNames PinmvpRichard MacCutchan30-Jan-13 10:10 
GeneralFound the Answer PLease Read PinmemberForNow30-Jan-13 10:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 28 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid