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

D

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.
 
C

Chris Marlow

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