How do I delete a placeholder programmatically?

[Maredith]

I'm using the Office 2003 package. (Will be transitioning soon) I'm trying to
use a macro to export data from Excel to PowerPoint for monthly briefings. I
want to put the data in a table. Right now, I'm using using the "Add" method
to the "Slides" collection with "ppLayoutTable" layout option. Then I add a
table to the slide and assign it to a shape opject, e.g.
Set MyShape = ppSlide.Shapes.AddTable(intLinesPerSlide, 6, 35, 125, 650,
320)
and populate the cells.

Everything works except when all is finished, the placeholder is still there
on the slide. By that I mean there is a placeholder and message in big bold
letters "Double click to add table". It doesn't show in slideshow but I want
to hand this to others to use.

Any ideas of either how to delete the placeholder or what other layout I
should use?

 

[John Wilson]

Maybe ppLayoutTitleOnly?
--
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

 

[Maredith]

Thanks so much. That worked. I had tried that, got an error, didn't follow
through. But with a minor change in how I was handling shapes, it works.

I appreciate your help.

 

[Maredith]

Thanks - I tried the first suggestion first and since that worked, didn't
move on the the second. But I have another app, does the same thing, but
since I'm the only "user" and it's not a problem for presentation, I've been
just "living with it". Your second suggestion for actually deleting the
placeholder may be a better solution for that particular scenario.

Thank you so much.
Maredith