@Aravindh

I'm afraid Eikon COM APIs libraries can only be used in 32-bit Excel.

Hi Alex,

Thanks for the reply. Could you please confirm whether in spite of having VBA71-32bit_CommonControl-32bit_x86.exe, Eikon VBA can be run only from Excel 64 bit?

Aravindh

Hi Aravindth,

Let me try to clarify, as you mixed some unrelated things in your follow-up question.

1. Windows operating system does not allow the execution of code compiled with mismatched bitness. In other words dlls compiled as 32-bit cannot be loaded into 64-bit processes and dlls compiled as 64-bit cannot be loaded into 32-bit processes.
2. Eikon COM APIs libraries are all compiled as 32-bit. For this reason they cannot be used in any 64-bit processes including 64-bit Excel.
3. Eikon application integrates Visual Basic Editor, which allows users to write and execute VBA code to automate tasks in Eikon application similar to how VBA can be used for task automation in Microsoft Office.
4. Eikon application is compiled as 32-bit. When Eikon is installed on a machine with 32-bit MS Office, Visual Basic Editor installed with Office is also utilized by Eikon. When Eikon is installed on a machine with 64-bit Office, Visual Basic Editor installed with Office cannot be utilized by Eikon because of mismatched bitness (64-bit VBE cannot be loaded into 32-bit Eikon process). To be able to use VBA in Eikon appication one needs to install 32-bit VBA by running VBA71-32bit_CommonControl-32bit_x86.exe.
5. Installing 32-bit VBA allows VBA to be used in Eikon application, but it has no effect on 64-bit MS Office, which can only utilize 64-bit VBA. After installing 32-bit VBA for Eikon, 64-bit MS Office continues to utilize 64-bit VBA installed as part of MS Office. Eikon COM APIs compiled as 32-bit libraries cannot be utilized in 64-bit Excel regardless of whether one installs 32-bit VBA for Eikon.