title: A way to refresh without manually select text file in excel?
body: <pre><code>Data &gt; from text &gt; Import text file &gt; ( manually select file )
  </code></pre>
  
  <p>I'm using excel 2010 . In the older version I use to be able to click "refresh' and excel would know which csv to refresh my file without asking to select the file manually. </p>
  
  <p>Is there a way to force excel to know which csv to select when I refresh the data ? ( Workbook connection > refresh > ..) 
  instead of excel prompt me back to > Import text file> ( manually .. ) </p>
  
  <p>What would be an easier way to do this ? I tried macro . </p>
  
  <pre><code>Sub Macro1()
  
      ActiveWorkbook.Connections("mismatch").Refresh
          With Worksheets("0Mismatch").QueryTables(1)
          .Connection = "TEXT;" &amp; ThisWorkbook.Path &amp; "c:\myfile.csv"
          .Refresh BackgroundQuery:=False
       End With
  End Sub
  </code></pre>
  
  <p>But it doesn't quite work.</p>