title: VBA and Excel running in parallel
body: <p>This is a question that I have always had but never really gave it much though.</p>
  
  <p>What I have at the moment is a worksheet that displays data, and the user refreshes whenever needed. So:</p>
  
  <ol>
  <li>User triggers a VBA Function</li>
  <li>VBA Function gathers data and analyses WHILE USER WAITS</li>
  <li>VBA Function dumps the result on the spreadsheet</li>
  <li>User continues viewing data</li>
  </ol>
  
  <p>Since the data analysis is all done internally in VBA (No use of workbook, only recordsets, arrays, library etc.) I wanted to somehow be able to allow the user to continue viewing the original data, while VBA works on getting and analyzing new data. </p>
  
  <p>I know you cant use the workbook AND run VBA at the same time, but you can however, have two excel instances and work on one workbook while the other runs VBA.</p>
  
  <p>So could I somehow have my original excel instance call another excel instance and have it run the VBA while I work on my first instance?</p>
  
  <p>Any Ideas?</p>
  
  <p>(Also, not sure if the tag "Multithreading" is technically correct)</p>