EXCEL | VBA

we are moving to LSEG Workspace. I need to open a Workspace Excel with VBA. The workspace add-
in is inserted correctly via File --> Options and if you manually open an Excel, the workspace add-in is also included.
But if I call an Excel via VBA, unfortunately the workspace add-in is missing.
What must the VBA code be to open a Workspace Excel? Which libraries are needed if necessary?
This worked before, but it didn't work with LSEG Workspace.
SET XL = CreateObject("Excel.Application")
Set xlWbk = xl.workbooks.open(strFileName, 3, False)
XL.Visible = True
May I confirm is the code client is using correct? I have already engaged our tech team for the missing workspace add-in but just want to make sure if the code is correct when calling Excel via VBA
Answers
-
0
-
Hello @Jirapongse Please see client's response:
We are unfortunately not making any progress. We need a solution that, with VBA calling an Excel
,the LSEG Workspace Addin is also available in the Excel register. Otherwise we have production problems.
Client is requesting a defnite answer, and not a link to discussion forums since they are unable to have any progress.
0 -
The problem should be in the Workspace Excel Add-ins itself.
Please escalate this case to the Workspace Excel Add-ins team to investigate this issue.
0 -
Hello @Jirapongse thank you for the response,
Sorry is there no VBA code to open workspace excel?
I think we should try first the VBA code that can open workspace excel, or are you saying that the code client is using should work that is why it is determined that the problem is in the addin?
0 -
Please escalate this case to the Workspace Excel Add-ins team to investigate this issue.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 689 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 24 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 711 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
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛