title: Runtime error 1004 - Excel cannot find the text file to refresh this external data range
body: <p>I have recorded the macro -below - to import a csv file</p>
  
  <p>If I try to modify the name of the file to import a different one (say 2017-05-01) it gives me error: Runtime error 1004 - Excel cannot find the text file to refresh this external data range. </p>
  
  <p>If I modify the range it works, but not when I modify the file name. 
  My excel is running on a Mac. The only item I can think of is that my disc is encrypted... any idea?</p>
  
  <pre><code>    With ActiveSheet.QueryTables.Add(Connection:= _
          "TEXT;/Users/dl/Documents/Annual_renewal/262_3297_2017_04_30.csv", _
          Destination:=Range("A411"))
          .Name = "262_3297_2017_04_30"
          .FieldNames = True
          .RowNumbers = False
          .FillAdjacentFormulas = False
          .RefreshOnFileOpen = False
          .BackgroundQuery = True
          .RefreshStyle = xlInsertDeleteCells
          .SavePassword = False
          .SaveData = True
          .AdjustColumnWidth = True
          .TextFilePromptOnRefresh = False
          .TextFilePlatform = xlMacintosh
          .TextFileStartRow = 2
          .TextFileParseType = xlDelimited
          .TextFileTextQualifier = xlTextQualifierDoubleQuote
          .TextFileConsecutiveDelimiter = False
          .TextFileTabDelimiter = False
          .TextFileSemicolonDelimiter = False
          .TextFileCommaDelimiter = True
          .TextFileSpaceDelimiter = False
          .TextFileColumnDataTypes = Array(1, 1, 1, 1, 5, 1, 1)
          .Refresh BackgroundQuery:=False
          .UseListObject = False
      End With
  
  End Sub
  </code></pre>