Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by Ripley79 · Nov 09, 2015 at 03:00 PM · excelvbacomadfin

How does AdfinX, DEX2 RSearch etc., now stored in X, Y or Z Bin folders, affect my VBA API calls?

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

1 Reply

  • Sort: 
avatar image
Best Answer
Answer by LarryT · Nov 09, 2015 at 03:50 PM

The first part below is taken from the Eikon Help Files - Thomson Reuters Eikon Deployment, Basic Configuration for Thomson Reuters Eikon, Creating and Managing Configuration Files on a Local Drive.

Location of files on Windows 7 and Windows 8

The default location of local configuration files depends on the security group of the user installing Thomson Reuters Eikon.

Since the name of the folder containing the software package changes dynamically for each update, the path to the configuration files too is dynamic, in other words Update based dynamic folder names.

Security Group Administrator %ProgramFiles%\Thomson Reuters\Eikon\folder name of current package: X or Y or Z\Config.

Security Group Standard User %LocalAppData%\Thomson Reuters\Eikon\folder name of current package: X or Y or Z \Config.

Versions 4.0 to 4.0.22: Fixed Folder Name.

In versions 4.0.xx to 4.0.22, the configuration folder was under the folder named after the version number.

For example: %ProgramFiles%\Thomson Reuters\Eikon\4.0.22\Config

Version 4.0.23 Onwards: Dynamic Folder Names.

With versions 4.0.23 onwards, there are dynamic folders under the main Thomson Reuters\ Eikon folder, folder names: X, Y, and, Z.

X is the current package at the first installation; after an update, a new folder called Y is created in the Eikon folder.

On restarting the application, X is designed as the backup package, and Y automatically becomes the current package.

At the next update, a third folder called Z is created

On restarting the application, X is deleted, Y becomes the backup, and Z becomes the current package

At the next update, the naming convention loop begins: the new package is X, Z becomes the backup, and Y is deleted

For example: %ProgramFiles%\Thomson Reuters\Eikon\X, Y, Z\ Config

Note: Local configuration files are automatically moved to the new location after the upgrade.

How does this affect AdfinX, DEX2, RhistoryAPI etc? Other folders and files are also updated, for example the Bin folder, which contains all the AdfinX and other API dlls. So there will be a Bin folder in an X, Y or Z in;

Security Group - Administrator %ProgramFiles%\Thomson Reuters\Eikon\folder name of current package: X or Y or Z\Bin

Security Group - Standard User %LocalAppData%\Thomson Reuters\Eikon\folder name of current package: X or Y or Z \Bin

So, what is the effect of this with my Excel for Eikon VBA API calls? With VBA users in Excel when the file containing the references to the dlls is opened, at startup the path of the addon is obtained and set as the default path. If VBA doesn’t find a reference it will look into this path and update the reference accordingly.

If the Y/Bin folder is removed and X/Bin exists when the application is loaded, references to Y should be changed to X automatically.

If the Y/Bin folder still exists VBA shouldn't change the reference. But the VBA API provided to create the object (using RegfreeCom) will create the object using the correct dll in the correct folder.

Rotation will not occur if TR Excel is running. It only happens on upgrade during which time the desktop and excel will not be running so dlls will not disappear mid-session. Also, deletion cannot occur if a dll is loaded. The apps will implement a reading of EikonRoot.xml on startup to figure out the latest Eikon version folder and do dynamic loading.

So the VBA and API calls should work correctly even if the reference contained in the project is not the right one.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
1 Person is following this question.

Related Questions

OK, so how do I get the Eikon for Excel/Eikon - Microsoft Office default AdxRtHistory fields then?

Can I determine the Connection state of Eikon Excel with VBA?

Corporate Action Field In Excel

Setting up VBA in Thomson Reuters Eikon

I like to write VBA code to disable Excel to update links to TRD on Workbook_Open

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges