title: How to update Excel Table using VBA while maintaining table's formulas
body: <p>I have a spreadsheet that defines several Excel tables which include both source data and functions using the source data.  For example, a table named MyTbl consists of three "source columns" and one formula column ...</p>
  
  <pre><code>Part   Price  Qty  Extended Price
  ------ -----  ---  --------------
  Shoe   5.50   10   =(MyTbl[[#ThisRow],[Price]])*(MyTbl[[#ThisRow],[Qty]])
  ...
  </code></pre>
  
  <p>Periodically, the source columns must be replaced by values from a CSV file, but the formula column(s) should remained unaffected.  The file is something like:</p>
  
  <pre><code>Shoe,5.65,98
  Coat,12.65,223
  ...
  </code></pre>
  
  <p>How do I "refresh" the source columns while maintaining the existence of the Excel Table and its formulas?  I'd like to do this in VBA as the CSV file does not have a consistent name or path.</p>
  
  <p>Thanks in advance.</p>