Changing link path in MS Publisher.

[edwone]

Hello, this is my first post on this forum and wonder if someone could give me some guidance on this:
I have a publisher file with over a hundred of Excel tables pasted as links. I would like to change the path for the sources of all links, and I guess only a macro could do that… I have done very little with macros in Excel, but am at a loss on how to do this in Publisher:
I would like to get this accomplished, for example:
C:\my folder\subfolder\CATALOGUE2007-forPublisher.xlsx!8!R9C6:R13C8
to C:\newfolder\CATALOGUE2007-forPublisher.xlsx!8!R9C6:R13C8
from C:\my folder\subfolder\CATALOGUE2007-forPublisher.xlsx!20!R22C3:R45C8
to this:
C:\newfolder\CATALOGUE2007-forPublisher.xlsx!20!R22C3:R45C8

Thanks,
Eduardo

[mbm123]

You want the code embaded in excel?

[edwone]

Hi, I checked the documentation for VBA in MS Publisher, and I concluded that there is no way to do that... such method is not available. You can change the path in other applications, but not Publisher
According to what I read and tried, I couldn't change SourceFullName from LinkFormat.
I'm still hoping I'm wrong.

Thanks,
Eduardo