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! :)

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! :)

Awesome webpage Jon! So a question:

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.

Does this mean that my content should be formatted the way I want it to look
in Excel first so that it looks how I want it to look in Powerpoint? So I
should program it into my Excel macro to make my content look pretty, then
program the copy and paste into PPT?

Thanks!!


"Jon Peltier" wrote:

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! :)

Does this mean that my content should be formatted the way I want it to
look
in Excel first so that it looks how I want it to look in Powerpoint? So I
should program it into my Excel macro to make my content look pretty, then
program the copy and paste into PPT?

Exactly. In my experience, content from one program looks best in another
program if you minimize how much the parent program has to tweak it. So,
yes, make the graphics pretty enough for PowerPoint in Excel, so the most
you might need to do in PowerPoint is scale it to fit (and try to keep
scaling to a minimum, say between 80% and 125% of the original). And for all
the reasons cited, I prefer using CopyPicture + Paste over Copy + Paste.

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