Hi there
I am using Excel 2002.
On cell A1, I have text "Apple",
On cell A2, I have text "Banana".
I also have a powerpoint file with two text boxes
What i wanna do:
1)
To create a link between this Excel file and this Powerpoint files.
So, that, "Apple" will appear in one text box in Powerpoint, and
"Banana" will appear in another text box.
2)
Also, whatever i change or update the Excel cell e.g. "Apple", it will
be changed in Powerpoint automatically.
Any tips?
Thanks a lot.
cheers:)
Michael Koerner - 09 Jul 2006 15:15 GMT
Jon Peltier a Excel MVP has a macro that will do what you want. Look here
http://peltiertech.com/Excel/Hyperlinks.html

Signature
<>Please post all follow-up questions/replies to the newsgroup<>
<><>Email unless specifically requested will not be opened<><>
<><><>Do Provide The Version Of PowerPoint You Are Using<><><>
<><><>Do Not Post Attachments In This Newsgroup<><><>
Michael Koerner [MS PPT MVP]
| Hi there
|
[quoted text clipped - 20 lines]
|
| cheers:)
Steve Rindsberg - 09 Jul 2006 18:23 GMT
> Hi there
>
[quoted text clipped - 14 lines]
> Also, whatever i change or update the Excel cell e.g. "Apple", it will
> be changed in Powerpoint automatically.
Do you want the PPT show to change DURING a slide show or is it enough that it
updates from the XLS each time you open the PPT file?
If the latter, just select the text in Excel, copy it, then go to PPT and
choose Edit, Paste Special, Link to paste in LINKED text.
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================