Excel Shapes selection problem

[zen35111]

Hi

I'm trying to determine which shapes (images in my case) are selected
in Excel (Office 2007). However, attempting to get anything useful
from the IDispatch returned from application->selection fails e.g.

CComQIPtr<Excel::ShapeRange> ShpRng = pAppXL->Selection;

results in SHpRange being NULL.

Has anyone actually succeeded in using the application Selection
property in Excel from a COM addin, or is this a big bug in Excel?

Incidentally, trying the window Selection property returns the same
IDispatch, again with no useful interface.

Thanks

Steve H

 

[zen35111]

Typically, I found the answer empirically, five minutes after posting:
If an image is selected you get either a pointer to a Picture or
Pictures object, depending on whether one or more images is selected.
So, with

CComQIPtr<Excel:icture> pic = pAppXL->Selection;

pic is none null if a single image is selected.

Steve H