title: running excel macro from another workbook
body: <p>I have a macro that is on a server. I need to be able to run it from different workstations that connect to this server.</p>
  
  <p>Currently I am doing:</p>
  
  <pre><code>Application.Run ("L:\database\lcmsmacro\macro1.xlsm!macro_name") 
  </code></pre>
  
  <p>The error message I am getting is "The macro may not be available in this workbook #1004"</p>
  
  <p>I have already made sure that my security settings are set on the lowest level.</p>
  
  <p>How do I run a macro from another workbook which is hosted on a different server?</p>
  
  <p>would using add-ins help me?</p>