title: change link file path in excel
body: <p>I would like to know if it is possible to change the file path of a link in excel, using text in another cell. The trick here is that the source workbook is not open at the same time as the one that has the link in it, and is not located in the same folder.  </p>
  
  <p>ie: if once cell has a link like:   </p>
  
  <pre><code>='C:\thanks\forthehelp\01\[eg.xlsx]worksheet'!A1
  </code></pre>
  
  <p>and I want to change the file based on text input from a cell, ie: cell A1 has some text: "02"</p>
  
  <pre><code>='C:\thanks\forthehelp\&amp;A1&amp;\[eg.xlsx]worksheet'!A1
  </code></pre>
  
  <p>to get </p>
  
  <pre><code>='C:\thanks\forthehelp\02\[eg.xlsx]worksheet'!A1
  </code></pre>
  
  <p>I know the above example doesn't work, but i think it illustrates what i want to do here. Any help would be really appreciated. I hope this makes sense. </p>
  
  <p>Thanks.   </p>