title: VBA reading non-english characters causes errors
body: <p>I am using a macro that reads every excel file in one folder and subfolders and refreshes it by opening the file and closing it with 'save changes' attribute as True. The problem is that VBA doesn't read non-english letters correctly and it causes error when trying to save the spreadsheet. My region settings in Windows control panel are correct. When I try to use the beta option of using Unicode UTF-8 for every language it works but that causes a lot of other programs I use to display some weird characters. The language I try to incorporate is polish. Any idea what to do?</p>
  <pre><code>Sub RefreshExcelDocs()
  
  Const startFolder As String = &quot;C:\Users\Patryk\Downloads\Przykład óżęą\Folder\&quot;
  Dim file As Variant, wb As Excel.Workbook
  
  For Each file In Filter(Split(CreateObject(&quot;WScript.Shell&quot;).Exec(&quot;CMD /C DIR &quot;&quot;&quot; &amp; startFolder &amp; &quot;*.xl*&quot;&quot; /S /B /A:-D&quot;).StdOut.ReadAll, vbCrLf), &quot;.&quot;)
      Set wb = Workbooks.Open(file)
      wb.Close SaveChanges:=True '
      Set wb = Nothing
  Next
  
  End Sub
  </code></pre>