Sunday, February 22, 2015

VBA in 64 bits, yes or no.

VBA in 64 bits, yes or no.

Do you want to know if we could do VBA in 64bits? The quick answer is NO. The smart answer is NO. The crazy programmer will say nothing is impossible. At the end, the answer will be NO. If you want to know why, you are at the right place.

First, VBA stands for Visual Basic for Applications. VBA is an old type of programming language. I would say VBA is a legacy code. VBA is attached to a host program. That host program is historically made in 32 bits. The best example is MS-Excel (32 bits). So, if MS-Excel on your computer is in 32 bits, then VBA is in 32 bits. Period! This principle is also true for every other application with a VBA inside : AutoCAD, See Electrical Expert, SolidWorks, Catia, ArcGis, Microstation, Lotus, MS-Word, MS-Access, MS-Excel, EPlan…

There is an important fact. Many companies use special software for their all day operations. In many case, companies choose to install the 32 bit MS-Office version to make sure that those software don’t have compatibilities issues.  Just think for 1 second. Your main ERP do import and expert using a 32 bits driver.

In the bottom line, VBA is in 32 bits.