title: VBA equivalent to VBScript's 'SetLocale' function?
body: <p>To summarize my problem, I'm currently having the exact same issue as the person from <a href="https://stackoverflow.com/questions/19289265/convert-date-string-value-from-u-s-to-native-date-with-current-locale-u-s">this question here</a>. I'm trying to parse a US date into an Excel sheet that has German as default and gives me a type mismatch on most of the dates because of it.</p>
  
  <p><code>SetLocale</code> sounded like the perfect solution to my issue, but after a minute of further research I discovered that <code>GetLocale</code> and <code>SetLocale</code> are apparently <strong>not</strong> supported in VBA.</p>
  
  <p>It <em>sort of</em> worked when I assigned the parsed date to a String variable (I end up with a column using either <code>MM/DD/YYYY</code> or <code>DD/MMM/YYYY</code> format depending on whether or not I had a type mismatch, as long as I use <code>On Error Resume</code>), but I need them in a <code>MM/DD/YYYY</code> date type/format in order to compare all the parsed dates to a specific date in another cell (attempting to determine if the site has had any updates since the date entered in the specific cell).</p>
  
  <p>I've also tried doing <code>TimeStamp = Format(TimeStamp, "MM/DD/YYYY")</code> (TimeStamp being a variable containing the parsed date), but it doesn't seem to be working- most likely due to the type mismatch error.</p>
  
  <p>If anyone knows a VBA equivalent of the <code>SetLocale</code> function used in the linked question for me to try out, I would greatly appreciate it. If there isn't any, I'll be happy to amend my question and add my current code here to try and hammer out a solution together.</p>
  
  <p>Thank you for your time and your help.</p>