Opening OLEOBJECT

B

Barb Reinhardt

I have an embedded Excel worksheet in PowerPoint. It's tied to a shape I'm
calling myShape. How do I open it in the native excel application? I can
do it "manually", so I know it can be done.
Thanks,
Barb Reinhardt
 
P

Peter T

ActiveSheet.OLEObjects("Object 1").Verb

or if you've already got a Shape

myShape.DrawingObject.Verb

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting chart title from Embedded Excel Chart in PowerPoint 1
Macros tied to Check Boxes in Excel 1
Extracting Excel2007 data from structured Storage 0
Opening embedded Excel 2007 Object in a PPT presentation 1
Finding Embedded Object Type in Worksheet 3
Copy used range from one worksheet to another (and lose the pivot) 3
Activate PowerPoint from Excel 1
Copy and Paste shape as picture 7

Top