View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] zen35111@zen.co.uk is offline
external usenet poster
 
Posts: 2
Default 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