VBA Code errors out on Office 64-bit

neodjandre

Well-known Member
Joined
Nov 29, 2006
Messages
926
I am getting an error that my code needs to be updated for Office 64-bit systems.

Code:
Private Declare Function GetTimeZoneInformationAny Lib "kernel32" Alias _
  "GetTimeZoneInformation" (buffer As Any) As Long


error says: please review and update Declare statements and then mark them with the Ptrsafe attribute

I can't understand what changes need to be made as this works fine on Office 32-bit.
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,109,026
Messages
5,526,325
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top