title: Get Timezone Information in VBA (Excel)
body: <p>I would like to determine a time offset to GMT/UTC (including daylight saving time) for different countries at a specific date in VBA. Any ideas? </p>
  
  <p>EDIT (from self-answer):</p>
  
  <p>Thank you 0xA3. I quickly read-over the linked page. I assume that you can only get the offset to GMT for the local where windows is running:</p>
  
  <pre><code>ConvertLocalToGMT    
  DaylightTime  
  GetLocalTimeFromGMT          
  LocalOffsetFromGMT
  SystemTimeToVBTime
  LocalOffsetFromGMT
  </code></pre>
  
  <p>In Java you can do the following:</p>
  
  <pre><code>TimeZone bucharestTimeZone = TimeZone.getTimeZone("Europe/Bucharest");
      bucharestTimeZone.getOffset(new Date().getTime());
  
  Calendar nowInBucharest = Calendar.getInstance(TimeZone.getTimeZone("Europe/Bucharest"));
      nowInBucharest.setTime(new Date());
      System.out.println("Bucharest: " + nowInBucharest.get(Calendar.HOUR) + ":" + nowInBucharest.get(Calendar.MINUTE));
  </code></pre>
  
  <p>This means I can get the offset for different countries (timezones) and I thus can also get the actual time lets say in bucharest. Can I do this in VBA?</p>