VBA powerpoint dynamic text (referenced to excel) in text box

[intoit]

Hi,

Is it possible to create a vba macro that generates the text in a specified
text box, whereby a small portion of the text is 'dynamic'. For example,
suppose I wanted a text box on a powerpoint slide to read something like,
"The percentage of people who desired the prodct was 77%. This means that
approximately 8 out of 10 people were interested in potentially sampling the
product."

Okay, easy enough to do the above in vba. However, how can the 77% be
referenced to a cell wtihin an excel worksheet, which will change in value
from project to project? Any ideas or references? thanks.

 

[intoit]

I've taken alternative track on this one. Rather than try to build the text
within powerpoint referencing excel, I've built the text within the excel
spreadsheet with reference to the relevant cells. Now, I've just go to copy
and paste the contents of the cell into the relevant powerpoint textbox,
which may prove to be easier.