what is difrence between 64 bit VBA & 32 bit VBA? & what is effact of same to run VBA on diff.PC.?

[Chirag R Raval]

Dear All,

What is difference between 64 bit VBA & 32 bit VBA? & what is effect of same to run VBA on another / difference pc?

What precautions should be taken before jump on other pc?
How to construct code to run regardless O/s or Board 64/32 ?
Motherboard/Processor construct 32/64 effect on VBA?
Operating System 32/64 Effect on VBA?

Regards,
Chirag Raval

 

[Chihiro]

It doesn't matter x86/x64 in most cases for VBA

There are few things that is going to have major impact.
1. When using database connectors. -

a. x86 Access cannot be connected to via x64 Excel.
b. Connector/Provider bitness must match that of Excel
c. x86 & x64 Office cannot co-exist in same environment​

2. When using API call to external library
3. Certain Shell Command must be executed using full path when using x64

a. Ex. Telnet (there's x86 & x64 versions, and you must explicitly specify the one you need)​

For making API call compatible, see link.
https://msdn.microsoft.com/en-us/library/office/ee691831(v=office.14).aspx

You should also read...
https://support.office.com/en-us/ar...f-Office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261

For OS...
Between different Windows... unless you are using external library, it shouldn't matter much.
OSX, is another matter. If you really want to make it compatible between Windows and OSX, you need to write code and test on both (or limit it to standard set of VBA function). There are many Windows specific methods used in general (Scripting.Dictionary, FSO, MSXML2 etc).

 

[Marc L]

Hi !

Many ActiveX do not work under Excel 64 bits version,
the reason why Microsoft advises to install 32 bits version …
​