MSGraph in PowerPoint

[Guest]

I have a few graphs in PowerPoint that are linked to Excel. The directory of
the Excel files has changed. I would like to know how to change the directory
of the links in PowerPoint using VB.

 

[Steve Rindsberg]

I have a few graphs in PowerPoint that are linked to Excel. The directory of
the Excel files has changed. I would like to know how to change the directory
of the links in PowerPoint using VB.

Change OLE links
http://www.rdpslides.com/pptfaq/FAQ00759.htm

 

[Guest]

I have tried that but it doesn't work. It only changes the links of the
PowerPoint object and not the MSgraph object. If you select the graph and
click Edit Links it will show you the changed link and then if you open the
graph and then click Edit Links it will show you the old link. The link the
open graph has it the one that counts. Do you have any idea how to change
that one?

 

[Guest]

I have tried that but it doesn't work. It only changes the links of the
PowerPoint object and not the MSgraph object. If you select the graph and
click Edit Links it will show you the changed link and then if you open the
graph and then click Edit Links it will show you the old link. The link the
open graph has it the one that counts. Do you have any idea how to change
that one?

 

[Steve Rindsberg]

I have tried that but it doesn't work. It only changes the links of the
PowerPoint object and not the MSgraph object. If you select the graph and
click Edit Links it will show you the changed link and then if you open the
graph and then click Edit Links it will show you the old link. The link the
open graph has it the one that counts. Do you have any idea how to change
that one?

Not a clue, unfortunately.

MSGraph doesn't tell VB/VBA anything about the links other than "Yeah, I got links.
Waddaya wanna make of it, fella?"

There's nothing much you can do with 'em in code.

 

[Guest]

Thanks for all your help so far Steve. Is there anyway that I can tell
PowerPoint and MSGraph to do a list of key strokes? e.g Alt-E, k, f,......

 

[Steve Rindsberg]

Thanks for all your help so far Steve. Is there anyway that I can tell
PowerPoint and MSGraph to do a list of key strokes? e.g Alt-E, k, f,......

You can try using SendKeys. It's not that reliable and can only work to TELL another app
what to do, not to ask it what it's up to, of course.