G
Grumpythedwarff
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.
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.