Excel Shapes selection problem
 

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

Excel Shapes selection problem
 

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::Picture pic = pAppXL-Selection;

pic is none null if a single image is selected.

Steve H

On 24 Jan, 15:16, wrote:
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