Macro routine to change links

[Daven Thrice]

Hi,

I have a presentation all worked up, and I want to be able to put different
data into it. Specifically, if I create a new set of charts and graphs in
Excel, I want to import them into the PowerPoint document such that they are
displayed rather than what was in there before. (I hope that makes sense!)

My thought is that, in VBA, there is probably a way to access the properties
for each embedded object within the document. Ideally, I would like to
re-embed another chart or graph. Realistically, I'm thinkin' I'm stuck with
linked objects. If I could access the "link property" and change that such
that it points to another file, that would work.

I could really use some pointers.

Thanks!

dt

 

[Kurt]

Daven,
to dynamically link powerpoint to external data sources, have a look at
www.take-off.as/datapoint

Alternatively you can use vba programming to accomplish that.

Kurt

 

[Daven Thrice]

Daven,
to dynamically link powerpoint to external data sources, have a look at
www.take-off.as/datapoint

That looks like a good potential solution, but I wonder if its too technical
for the users. They have enough "fun" creating excel spreadsheets. I will
need to set things up for them and give them a simple routine. Will your
product support that?

Alternatively you can use vba programming to accomplish that.

Arg!!! Bite your tongue. I shall pitch your control wholeheartedly so long
as it does not burden the end user nor require ongoing support. Wish me
luck!

Thanks,

dt

 

[Kurt]

You can also opt to exchange the data with datapoint to a powerpoint/ms
graph object and let the users play with the graph in powerpoint.
In this situation I expect that the data is already available (in excel) and
that the users are not entering it into excel.