Help About Excel 64 Bits

**cexarto** · 12-27-2012, 06:44 PM

Hi. Please I want your help . I have this file attached in Excel . This converts directions(column B) to coordinates(columns J and K) through Button GEOCODE.

The original File works only for 32 Bits. I have modified this adding "Module 1" in order to This works for both 32 and 64 bits

But , i don't have Excel 64 bits to test . Please I would like someone could test if the vba work. Only download the file and click in GEOCODE.

The original file is GoogleMapping.xlsm :
http://ramblings.mcpher.com/Home/exc...ownlable-items

I only added "Module 1". The code is red but it still works in 32 bits.

Thanks

**Leith Ross** · 12-27-2012, 07:26 PM

Hello cexarto,

Conditional Compilation of API functions can not be done inside a Sub or Function procedure. Your code should appear this way in the module...

#If Win64 Then
    Private Declare PtrSafe Function LoadLibrary Lib "kernel32" Alias "LoadLibraryA" (ByVal lpLibFileName As String) As LongLong
    Private Declare PtrSafe Function FreeLibrary Lib "kernel32" (ByVal hLibModule As Long) As LongLong
    Private Declare PtrSafe Function GetCurrentThreadId Lib "kernel32" () As LongLong
#Else
    Private Declare Function LoadLibrary Lib "kernel32.dll" Alias "LoadLibraryA" (ByVal lpLibFileName As String) As Long
    Private Declare Function FreeLibrary Lib "kernel32.dll" (ByVal hLibModule As Long) As Long
    Private Declare Function GetCurrentThreadId Lib "kernel32.dll" () As Long
#End If

**cexarto** · 12-27-2012, 07:35 PM

Hi Leith Rose. Thanks for reply

I have modified according your suggestion , but don't work in my Excel of 32 bits. My file attached works in your computer?

Thanks

**Leith Ross** · 12-27-2012, 07:48 PM

Hello cexarto,

Yes, I have Windows 7 64-bit. Are you planning on running this code on 32-bit systems and 64-bit systems?

**cexarto** · 12-27-2012, 07:58 PM

Yes , but i Only have 32 bits in my computer for testing. The original file doesn't works in 64 bits. So I modified this adding module 1 (my file attached) and now it still works in 32 bits but I dont Know if it works in 64 bits?. Please , test in your computer my file attached. Or maybe you have another better solution in order to this file works in both systems? . Thanks