<div>
Excellent, works like a dream. &nbsp;Thanks.
</div>


<div>
<div class="content wysiwyg-content">
I have a requirement to change the path (name) to a <b>number </b>of linked worksheets by code.<br />
I think it is something to do with the workbook.LinkSources but I am having some problems.<br />
<br />
Am I looking at the wrong thing? &nbsp;What is the property I should be loooking at? &nbsp;Best of all - does someone have a piece of code to do it and is willing to share it?
</div>
</div>


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?

Changing the path to linked excel worksheets programatically

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.