Excl objects pasted into VBA as object - Macro to list out the addresses

[BuJay]

I have a bunch of charts linked to excel from within powerpoint.

Can someone provide a macro that would list out the full addresses of each linked object, i.e., all of the source addresses? Printing to the immediate window is sufficient - I am just thinking that there is an improperly linked object somewhere and cannot expand the address string in the powerpoint edit links window. (See image)

 

[Domenic]

Thank you so much Domenic

You're very welcome, I'm glad I could help.

I'll try to figure out why this worked and the previous versions did not - but - alas - this worked! Thank you very much!

With the previous versions, we were checking whether the shape or placeholder contains a chart. Whereas with this version, we're checking whether the shape contains a linked worksheet object. These are two different types of objects. The latter is simply a shortcut to the file so that changes to the file will be reflected in your presentation. I know, it gets confusing.

 

[Jon Peltier]

I think the first version didn't work because it assumed the linked chart was in a placeholder. In my experience, most people just paste a chart onto a slide without regards to placeholders.

 

[Domenic]

I think the first version didn't work because it assumed the linked chart was in a placeholder. In my experience, most people just paste a chart onto a slide without regards to placeholders.

Actually, the first version assumed that the chart was pasted onto a slide. And the second one assumed that it was placed in a placeholder. It was the third one that worked, since the chart was inserted as a linked worksheet object.

Cheers!

 

[Jon Peltier]

Actually, the first version assumed that the chart was pasted onto a slide. And the second one assumed that it was placed in a placeholder. It was the third one that worked, since the chart was inserted as a linked worksheet object.

Cheers!

Oops! Guess I lost track.