title: VBA project can not detect foreign letters
body: <p>Whenever I try to take data from an xlsx document which consists of letters like &quot;ö ü İ&quot; and etc. I get some error.</p>
  <p>I have already tried to change the language of the program also the changing language for non-Unicode programs. It did not work</p>
  <pre><code>Sub Getdataclosed()    
      Dim src As Workbook        
      Set src = Workbooks.Open(&quot;C:\Users\ciyican\Desktop\Daily_LU31_DM_Report\nameofthebook.xlsx&quot;, True, True)
      
      ThisWorkbook.Activate        
      Worksheets(&quot;Sheet1&quot;).Range(&quot;A2:d26&quot;).Formula = src.Worksheets(&quot;Sheet1&quot;).Range(&quot;d8:G32&quot;).Formula        
      
      Set src = Workbooks.Open(&quot;C:\Users\ciyican\Desktop\Daily_LU31_DM_Report\nameofthebook.xlsx &quot;, True, True)
  
      ThisWorkbook.Activate
      Worksheets(&quot;Waste Claculation&quot;).Range(&quot;h3&quot;).Formula = src.Worksheets(&quot;Sheet1&quot;).Range(&quot;k7&quot;).Formula
  End Sub
  </code></pre>
  <blockquote>
  <p>Application defined or object defined error</p>
  </blockquote>