how do I convert an imported object to a drawing object?

T

Tony Logan

Here's what I'm doing: from Word, I open a PowerPoint file, cycle through
each slide, cycle through each shape, and extract the text within the various
shapes.

Most of this code I adapted from the PPTools site (this page in particular:
http://www.pptfaq.com/FAQ00594.htm), which has a pile of great help, in case
you haven't checked it out.

I'm getting a "Permission denied" error in my code, though, as soon as I
encounter a shape that contains data linked to an external file (an embedded
Excel file placed inside an AutoShape, in this case).

There's info in the PowerPoint help file on how to do this manually. I'm
wondering if there's a way to handle it programmatically.

Here's the info from the Help file:

= = = = = = =
Edit an embedded object without its source program

If an embedded object's source program is unavailable, you can convert it to
a Microsoft Office drawing object to edit. After you convert an embedded
object to an Office drawing object, it is no longer connected to the original
program.

1. Select the embedded object you want to convert to an Office drawing
object and edit.
2. On the Drawing toolbar, click Draw, and then click Ungroup.
3. In the alert message that appears, click Yes.
4. On the Drawing toolbar, click Draw, and then click Group.
= = = = = = =

Anyone know of a way to perform the above steps with code? I've tried
recording a macro, but it doesn't seem to include any way of handling the
dialog box that pops up asking me if I want to convert the shape to a drawing
object.

Thanks.
 

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

Top