VS MFC下操作excel时 Open出错（debug模式正确release报错），求助

[hdzhangnudt]

以下代码在debug模式下正常，一旦到release或release static下，则执行到Open就报错，
（VS2010，MFC，win7，32bit）

CApplication oApp;
CWorkbooks books;
CWorkbook book;
CWorksheets sheets;
CWorksheet sheet;
CRange range;
CRange rangV;
CString sTotalDangAn,strTotalUser,strTotalXingHao;
oApp.CreateDispatch(_T("Excel.Application"));
books = oApp.get_Workbooks();
book = books.Open(sPath, _variant_t(vtMissing),_variant_t(vtMissing), _variant_t(vtMissing), _variant_t(vtMissing),
_variant_t(vtMissing), _variant_t(vtMissing),_variant_t(vtMissing), _variant_t(vtMissing),_variant_t(vtMissing),
_variant_t(vtMissing),_variant_t(vtMissing),_variant_t(vtMissing),_variant_t(vtMissing),_variant_t(vtMissing) );

执行到此处后，转到：AfxCallWndProc的
CATCH_ALL(e)
{
lResult = AfxProcessWndProcException(e, &pThreadState->m_lastSentMsg);
TRACE(traceAppMsg, 0, "Warning: Uncaught exception in WindowProc (returning %ld).\n",
lResult);
DELETE_EXCEPTION(e);
}

[huangzongw]

检查一下debug下传人的调试路径与releas下的是否不同，如果sPath是相对路径，调试目录不同的话会有影响

[oyljerry]

先看看错误的信息是什么，是不是有配置跟debug不一致

[liuyuzhen_smile]

是不是变量赋值不对或者有的变量没有赋值导致的，自己调试看看

[zgl7903]

Release 版本也可以设置断点调试运行

[zhujinqiang]

设置断点调试一下