title: Declare PtrSafe Compatibility in Excel
body: <p>I am using this statement in VBA</p>
  
  <pre><code>Private Declare PtrSafe Function GetTimeZoneInformationAny Lib "kernel32" Alias _
    "GetTimeZoneInformation" (buffer As Any) As Long
  </code></pre>
  
  <p>This works fine with:</p>
  
  <ul>
  <li>Win 64-bit, Excel 2010 64-bit</li>
  <li>Win 64-bit, Excel 1010 32-bit</li>
  </ul>
  
  <p>However my client reported a compile error on the word <code>PtrSafe</code>. He is using Excel 2010.</p>
  
  <p>I am not sure why this happens. any ideas?</p>