title: call VBA macro from different computer over network
body: <p>I am hoping someone might be able to help me. </p>
  
  <p>My problem is essentially this: A Colleague enters information into an excel, which I then have to check and pass on by email. This is fairly time-critical.</p>
  
  <p>What I would like to do is</p>
  
  <ol>
  <li>have the colleague press a button that calls the macros on my computer (worksheet running continuously),or</li>
  <li>have my colleague email me and I have a macro in Outlook which checks for specific subject lines, or</li>
  <li>he saves it on the network, and I check every minute for new files in that folder. </li>
  </ol>
  
  <p>While the last two of these are possible, the outlook solution is - for several company policy reasons - the very last resort, and I would also like to avoid the ongoing checking for files as I am already having slight performance issues (large worksheet with lots of external links that are being feed real time). </p>
  
  <p>I am also open to all other suggestions someone might have. Thanks a lot!!</p>