title: Automatically refresh imported macros in excel
body: <p>I'm currently updating multiple separate excel documents to use macros.</p>
  
  <p>While each of these documents are separate there are a number of equations shared amongst them. To make my life easier I've exported my macros to a bas file which is then imported into each subsequent file. The issue I have at the moment is that occasionally some of these equations need to be changed or updated. This currently results in me having to go to every excel file, delete the previously imported bas file and reimport the new one. Is there a way to import the bas file through some form of symbolic link or to force Excel to check the location of the file and ensure that the bas file is up to date.</p>
  
  <p>Below is a simple use case, as I may have been rather unclear in my ramblings :</p>
  
  <p>Document 1 has one equation
  Macros: 
     Equation 1 : (value1 + value2) / value1 </p>
  
  <p>This is exported to macros.bas</p>
  
  <p>Document 2 uses the same Macro and thus just imports macros.bas:
     Equation 1 : (value1 + value2) / value1 </p>
  
  <p>Two days later I am informed that the equation should be modified such that the equation is divided by value2. To do this the following steps are performed.</p>
  
  <p>Step 1)
  The bas file is updated such that 
     Equation 1 : (value1 + value2) / value2</p>
  
  <p>Step 2) 
  Document 1 and Document 2 are opened
  Step 3) 
  I have to delete the old macros module and reimport the new one.</p>
  
  <p>Is there a way to automate Step 2 - 3, through symbolic linking or forcing excel to automatically refresh imported macros from the macros.bas ?</p>
  
  <p>Thank you for any response.</p>