Help!

  • Thread starter Thread starter brenda.dong
  • Start date Start date
B

brenda.dong

Hi all, i'm at work and i'm desperately trying to create some slides
using VBA in powerpoint but through Excel. Basically I have this slide
in ppt and I need to create 76 copies of it but with each copy i need
to change the text in the title/other textboxes as well as the chart.
I have a template and i can update it all of the objects for the first
copy but after that I'm stuck because if i duplicate the slide, the
names of the textboxes/chart object changes and I don't know how to
automate that for the other 75 slides. Can anybody help? Thanks!

Brenda
 
Because the title is almost certainly the first shape on the slide, you
can access the text with:

Presentations(1).Slides(xx).Shapes(1).TextFrame.TextRange.Text

where xx is the number of the slide you want to change. If you have some
way of knowing what text to put on what slide, you could do all the
copying and use

For Each sld in Presenations(1).Slides
sld.Shapes(1).TextFrame.TextRange.Text = <something>
Next sld

I don't program charts, so I'm not sure how to change that.

--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

(e-mail address removed) wrote in @y27g2000pre.googlegroups.com:
 
Back
Top