question

Upvotes
Accepted
Aravindh avatar image
1 ●1 ●1 ●1

ADXRT object is not getting created

EIKONCHECK.zip

In our VBA code, the ADXRT object is not getting created but at the same time the DEX2 object is getting created without issues. From Workbook open, we are calling a method which calls the respective functions to create the Reuters object. The DEX2 object is created but looks like ADXRT one is not created (It says nothing). PFA the EIKONCHECK.ZIP which was created to simulate this issue.





Below is the environment related details.

Reuters Eikon Version: 4.0.50 (4.0.50046)

OS: Windows 10

Office version: Office 365 64 bit


Our current Eikon version 4.0.50.046 for Workspace already contains the VBA71-32bit_CommonControl-32bit_x86.exe.

eikoneikon-com-api
1602114788130.png (32.1 KiB)
eikoncheck.zip (39.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Alex Putkov.1 avatar image   Alex Putkov.1

@Aravindh

Thank you for your participation in the forum. Are any of the replies below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply that best answers your question. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

Alex Putkov.1 avatar image   Alex Putkov.1

@Aravindh

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

-AHS

3 Answers

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

@Aravindh

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Aravindh avatar image
1 ●1 ●1 ●1

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

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.
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.