I have a requirement to change the path (name) to a number of linked worksheets by code.
I think it is something to do with the workbook.LinkSources but I am having some problems.
Am I looking at the wrong thing? What is the property I should be loooking at? Best of all - does someone have a piece of code to do it and is willing to share it?