How to automate "Excel data .. pasting to... powerpoint"

[dstdst123]

Hi folks

I am using both Powerpoint 2002 and Excel 2002.

I have an Excel spreadsheet with cell A1 - A10, filled with some text
and some number.

At the same time, in my Powerpoint, I have a text box on a slide.

I wanna copy & paste or export the cotent of A1-A10 in to that one
single text box in Powerpoint.

Questions:
1)
Is there an easy and automatic way to do this (say, if i don't want to
copy and paste every time) ?

2)
If i update and change, say cell A3, i wanna the changes automatically
reflected in the Powerpoint, is this possible ?

3)
If I have 3 different worksheet in my workbook, can I do the same and
to export and update my 3 slides in my powerpoint respectively?

Thanks a ton.

 

[Guest]

This does not do quite do what you want but is a simple option

Insert - Object - Create From File - Browse the file - Check 'Link'. You
will need to reforamt the object to suit.

When you open the presentation again you get an 'Update links' much as you
would in Excel.

You can automate data from Excel (or Access) into Powerpoint using VBA,
either from within Powerpoint itself or driven by Excel. If the above does
not meet your need I can dig out some code, although I'd say it is the most
fiddly of the Office apps to automate in my experience.

Thanks & regards,

Chris.

 

[Steve Rindsberg]

Hi folks

I am using both Powerpoint 2002 and Excel 2002.

I have an Excel spreadsheet with cell A1 - A10, filled with some text
and some number.

At the same time, in my Powerpoint, I have a text box on a slide.

I wanna copy & paste or export the cotent of A1-A10 in to that one
single text box in Powerpoint.

Questions:
1)
Is there an easy and automatic way to do this (say, if i don't want to
copy and paste every time) ?

2)
If i update and change, say cell A3, i wanna the changes automatically
reflected in the Powerpoint, is this possible ?

3)
If I have 3 different worksheet in my workbook, can I do the same and
to export and update my 3 slides in my powerpoint respectively?

I'd do more or less what Chris suggests except that Insert Object won't let you
choose which worksheet you want or what portion of the worksheet to insert.

Instead, start Excel, open the file, select the content you want in PPT and
press Ctrl+C to copy it.

Switch to PPT, move to the slide where you want the content, choose Edit, Paste
Special, Link.

Position and size the paste/linked content to taste.

Repeat for the other worksheets.

When you open the PPT file again, it'll update the links, bringing in any
changed data in your worksheets.