I'd like to extract some data from an embedded excel chart. I can figure
out how to do the excel piece, but don't know how to programmatically open
the chart in excel. How do I do that?
Thanks
Try:
ActiveWindow.Selection.ShapeRange(1).OLEFormat.DoVerb 2
Regards,
Shyam Pillai
Animation Carbon
http://www.animationcarbon.com
> I'd like to extract some data from an embedded excel chart. I can figure
> out how to do the excel piece, but don't know how to programmatically open
> the chart in excel. How do I do that?
>
> Thanks