ADXRT object is not getting created
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.
Best Answer
-
I'm afraid Eikon COM APIs libraries can only be used in 32-bit Excel.
0
Answers
-
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
0 -
Hi Aravindth,
Let me try to clarify, as you mixed some unrelated things in your follow-up question.
- 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.
- 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.
- 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.
- 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.
- 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.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 33 Data Model Discovery
- 682 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.8K Refinitiv Data Platform
- 622 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 83 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛