1) Should I write the macro in Excel or Powerpoint, or does it even
matter?

This is a matter of choice. I do it from Excel, since that's what I know
better.

2) Should I write the macro so that I'll just be copying objects in Excel
and pasting them as special objects in Powerpoint?

For most content, this works best:
Copy Picture Paste

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?

I find it easier to just have the code copy stuff and place it, without
having to do much replacing of existing information. It's easier to rerun
the code on a fresh template than figure out what is to be replaced.

I have a web page with lots of tips on this kind of activity:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"et10yl" wrote in message
...
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! :)