I have several hundred Excel files with data, and I'd like to produce a
Powerpoint presentation for each of these Excel files. I figure the best way
to go about this is programatically. I already have a Powerpoint template
with slides that already have the design layout set. The Excel data will
need to be placed in tables and graphs in the Powerpoint template. I realize
that I can probably farm this out, but I'd rather learn how to do this.

At this point, there are a few things my mind's circling about on:
1) Should I write the macro in Excel or Powerpoint, or does it even matter?
2) Should I write the macro so that I'll just be copying objects in Excel
and pasting them as special objects in Powerpoint?
3) Should I write the macro so that I select and copy specific values in
Excel, then select and paste over existing values (or in specific places) in
Powerpoint?

Any and all help on the above questions, and even other ideas that you have
that I haven't thought of, would be appreciated as I'm a budding programmer
and having tons of fun, though I get stumped often... Yay, what fun
learning! :)