Macro routine to change links

  • Thread starter Thread starter Daven Thrice
  • Start date Start date
D

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 said:
Daven,
to dynamically link powerpoint to external data sources, have a look at
www.take-off.as/datapoint
Click to expand...

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.
Click to expand...

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
 
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.
Click to expand...

You could do either with VBA; changing the link to point to another file is a
LOT simpler.

Show me the link and let me edit it
http://www.rdpslides.com/pptfaq/FAQ00433.htm
 
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.
 
Back
Top