Excel COM Add-in
Hi all,
hope someone have had the same problem and managed to solve it
I have set the COM add in to load at start up as following: File --> Options --> Add-ins --> Manage COM add-ins --> GO --> checked the box for the relevant Add-in --> Load Behaviour --> At Startup.
So far so good. I can close Excel, reopen it and the Add-in loads properly.
The strange behaviour happens when I open excel as an object via a VBA script running under Access. After Excel is opened as an object via a VBA script the COM add-in gets dropped. After Access has finished running the VBA script if I open Excel the COM add-in do not get loaded. If I go to File --> Options --> Add-ins --> Manage COM add-ins --> GO --> I can see the box for the COM add-in is unchecked despite was checked before.
Is there a way to avoid Excel dropping the COM Add-in when opened as an object? Or not to uncheck the COM Add in box so that if Excel is launched manually the COM Add-in will still be available?
This a strange and quite annoying behaviour as I use the COM add-in to download data and every morning I need to go back into Excel and load again the COM add-in.
Note that when Excel opens as an object via VBA I do not require to download any data. I just would love to have Excel not dropping the add in if opened manually after it has been opened and run as an object
Thanks for your help
Best Answer
-
Hello @fabio.agostini ,
This is not a situation that dev forums are most helpful for, the dev forums are most beneficial for general questions and discussions centered around Refinitiv APIs.
We have worked to verify the issue on ours side:
- We have confirmed with our product expert, that what you describe is not a supported workflow.
- They have verified that when they open an Excel object from Word, Refinitiv add-in is loaded correctly
- I have gone through the same simple Insert linked Excel object into Word - Refinitiv add-on remains loaded (please note that I am not an Eikon COM expert)
- Decided to go one step further, and test specifically loading Excel via VBA: on my side, Excel starts up via this VBA code, my Excel workbook does not load as I would expect it, however Refiniv COM add-in remains loaded as expected, this does not interfere with the COM add-in.
Some suggestions:
- You may wish to review article Automation add-ins for Excel are not loading after installing April 2021 security update.
- If this is not your scenario, and you would like to provide the exact sequence of steps and the minimal except of code to reproduce this on our side (are you able to reproduce with starting Excel via VBA from MS Word or only with MS Access?) we will verify and get back with any findings here.
1
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛