Changing the location of a linked object using VBA



I have around 50 tables that I have as linked objects from an Excel document.
If the Excel document is moved the links no longer work (as to be expected),
how do I use VBA to change the location of the source object for all of the
linked objects within the Publisher document?

I have found the sourcefullname property for shape objects, but this appears
to be a read-only property. I have also tried to create a new shape object
and then define the sourcefullname property but this also doesn;t work.



Justin Carella

Did you ever find a solution? I am also looking VBA to change the source code.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question