ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   the excel calling msquery question throught DDE (https://www.excelbanter.com/excel-programming/400578-excel-calling-msquery-question-throught-dde.html)

row wang

the excel calling msquery question throught DDE
 
Throw the Type mismatch Exception (Abnormal from HRESULT: 0x80020005
(DISP_E_TYPEMISMATCH)) when the excel the application called the Ms Query.
exe file .

Codes:
Microsoft.Office.Interop.Excel.Application m_excelComApp.GetExcelApp()

{

.......

}

try
{
m_excelComApp.GetExcelApp().DDEInitiate("MsQry32", "Query1");
}
catch (Exception ee)
{
MessageBox.Show(ee.Data + ee.Source + ee.Message);
}


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com