Help About Excel 64 Bits

[cexarto]

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]

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...

Please Login or Register  to view this content.

[cexarto]

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]

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]

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

[cexarto]

Please, someone who have Excel 64 Bits for helping with my question?