title: changing a data source for an excel oledb connection
body: <p>I have an excel workbook, with 10 sheets. Each sheet contains an oledb connection pointing to a .csv file.
  Each connection was originally created to point to a specific .csv file.</p>
  <p>I want to use VB to change the name of the .csv file.
  When I attempted to retrieve the name of the source file using:</p>
  <pre><code>?ActiveWorkbook.Connections(8).OLEDBConnection.SourceDataFile
  </code></pre>
  <p>nothing is returned. only whitespace.</p>
  <p>then I noticed, that using:</p>
  <pre><code>?ActiveWorkbook.Connections(8).OLEDBConnection.connection 
  </code></pre>
  <p>returns this:</p>
  <pre><code>OLEDB;Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=PAIDOFF_L2500;Extended Properties=&quot;&quot;   
  </code></pre>
  <p>I'm stumped... if the source is $Workbook$, how do change the location of the datafile.</p>