Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error on fetching object in OLEObject
I had a Ax in a OLEObject which is stored in the xls file and when I tried to
get the Object of the OLEObject, Excel crashes. Someone could help me? CComPtr<IDispatch pDisp; hr = pSheets-get_Item(CComVariant(wksndx), &pDisp); if ( FAILED(hr) || pDisp == NULL ) continue; CComQIPtr<XLS::_Worksheet pWorksheet = pDisp; if ( pWorksheet == NULL ) continue; CComPtr<XLS::OLEObjects pOLEObjects; hr = pWorksheet-raw_OLEObjects(vtMissing, NULL, (IDispatch**)&pOLEObjects); if ( FAILED(hr) || pOLEObjects == NULL ) continue; CComPtr<XLS::_OLEObject pOLEObject; long lOLEObjects = -1; hr = pOLEObjects-get_Count(&lOLEObjects); if ( FAILED(hr) || lOLEObjects < 1 ) continue; for ( long nOO = 1; nOO <= lOLEObjects ; ++nOO ) { CComPtr<IDispatch pDisp; pOLEObject = NULL; hr = pOLEObjects-raw_Item(CComVariant(nOO), (IDispatch**)&pOLEObject); if ( FAILED(hr) || pOLEObject == NULL ) continue; hr = pOLEObject-get_Object(&pDisp); //BUGING HERE !!!!!!!! if ( FAILED(hr) || pDisp == NULL ) continue; |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'Not Like' Error when fetching data from Access | Excel Discussion (Misc queries) | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
Get OLEObject.Object with Csharp | Excel Programming | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |