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