Macro to title slides

  • Thread starter Thread starter simonc
  • Start date Start date
S

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.
 
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.
Click to expand...

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.
 
Back
Top