I am not a C++ developer but I've found that to get some of my old VBA code
to run under XL2007 I had to replace some uses of DrawingObjects with
Shapes.

--
Jim
"ranga" wrote in message
oups.com...
| Hi All,
|
| I am trying to to capture a selected image from the excel (2007)sheet.
| I am quering for DrawingObjects in the selection. Excel crashes in the
| statement
|
'pDispatch-QueryInterface(__uuidof(MSExcel::DrawingObjects), (LPVOID*)&pDwo);'
|
|
| Here is the piece of code that i am using
|
| IDispatch *pDispatch = m_Application-GetSelection();
|
| if (pDispatch == NULL)
| return bRetVal;
|
| CComQIPtr<MSExcel::Range ranges;
| ranges = m_Application-GetSelection();
|
| MSExcel::DrawingObjects * pDwo = NULL;
| pDispatch-QueryInterface(__uuidof(MSExcel::DrawingObjects), (void
| **)&pDwo);
|
| When the last statment gets executed, excel crashes.
|
| can anyone tell me i have missed anything to make it work on Office
| 2007 Excel
|