Linking PPT bullet text to Excel

[Texas Longhorn]

Hi all,

I have a powerpoint presentation in which I'd like to link text to Excel. I have a slide that has 5 bullet points (these were created in PPT). Each bullet has a company name, current stock price, and some other text. I would like to link the current price to an Excel worksheet that I maintain.

I have succeeded in getting the PPT to link to Excel by using Copy/Paste Special/Past Link. However, my problem is that the formatting of the PPT slide is different that the Excel file (font size, color), and I cannot figure out how to make the pasted link take on the characteristics of the PPT bullet (other than to change the Excel file, which isn't an option).

Any ideas? Any help would be much appreciated.

Thanks,
Bill

I've also posted this query here: http://www.theofficeexperts.com/forum/showthread.php?p=29292#post29292

 

[Damon Ostrander]

Hi Tex,

I can't think of a "non-VBA" way to do this without modifying the Excel formatting. It can be done with VBA via a macro that would grab the appropriate cell data from Excel and paste it as a text string into PPT, which would maintain the existing PPT formatting.

Damon

 

[Texas Longhorn]

Thanks for the reply Damon...I'll get started going down that path. Too bad there's not a straight-forward way to do it like in Word.

Thanks,
Bill