Macro to title slides

[simonc]

I want to write a macro to take a list of figure numbers and figure titles
from an Excel spreadsheet and go through a powerpoint presentation adding the
titles to the Title field, and the corresponding figure number in a text box.
Unfortunately I am at a loss where to start. I'd be grateful for any help
especially in how to refer to the spreadsheet.

Grateful for any advice.

 

[Steve Rindsberg]

I want to write a macro to take a list of figure numbers and figure titles
from an Excel spreadsheet and go through a powerpoint presentation adding the
titles to the Title field, and the corresponding figure number in a text box.
Unfortunately I am at a loss where to start. I'd be grateful for any help
especially in how to refer to the spreadsheet.

So I'm clear on the concept, you've got something like this in Excel:

FigureNumber FigureTitle
1234 The Night Watch
2345 The Thinker
3455 Mona Lisa

Is that right?

If so, and if you just need a solution off the shelf, have a look at our Merge
add-in:

http://www.pptools.com/merge/

The free demo'll let you test it thoroughly.

If you really want to write it yourself, start here:

Where it starts: the DisplayData project by Naresh Nichani and Brian Reilly
http://www.pptfaq.com/FAQ00784.htm

Using Excel and Access data in PowerPoint Tables (by Brian Reilly and Naresh
Nichani)
http://www.pptfaq.com/FAQ00892.htm

These don't do exactly what you're after in PPT but give good examples of
extracting data from spreadsheets.