View Single Post
Old 24-09-2008, 12:08   #1
absthechatter
Inactive
 
Join Date: Dec 2004
Posts: 310
absthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really nice
Excel VB Code to automatically assign title in PowerPoint

I have written a Macro that copies a chart from Excel, creates a new slide in Powerpoint adds a blank title ("Click to add title") to the top and pastes the chart as a picture. What I really want to do is get the Macro to add the actual title I want, this will be different for each chart.
The code for title I have at moment is;

SlideCount = PPPres.Slides.Count
Set PPSlide = PPPres.Slides.Add(SlideCount + 1, ppLayoutTitleOnly)
PPApp.ActiveWindow.View.GotoSlide PPSlide.SlideIndex

Any idea what I add to get it to write title??

Any help would be much appreciated.

Abs
absthechatter is offline   Reply With Quote