Excel(2007) crashes on quering for DrawingObjects selection

[ranga]

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:rawingObjects),(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:rawingObjects * pDwo = NULL;
pDispatch->QueryInterface(__uuidof(MSExcel:rawingObjects),(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

 

[Jim Rech]

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
| 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:rawingObjects),(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:rawingObjects * pDwo = NULL;
| pDispatch->QueryInterface(__uuidof(MSExcel:rawingObjects),(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
|