Facing issue on SFIL global

Hi Team,
Query :
SFIL global issue
The first issue is they would like to know if there is a VB code for Workspace refresh function as they have a file that gets their data for BID and ASK which uses workspace formula and they also have MID which is the average of BID and ASK but doesn't use workspace formula. When they click F9 it refresh the sheet but doesn't retrieve MID data it only gets the Bid and ask. However when they click on Refresh button in Workspace tab, it retrieves all data bid, ask and mid.
The second issue was they have another file which use their own VB code, when they try to run their VB code it retrieves the data after running the VB code but what they want is when the VB code is running the data should be retrieved as it works in Eikon but in Workspace it doesn't.
Answers
-
Hi Team
Good day!
Following up on behalf of my colleague Vaishnavi.
Can we please have an update on the client's query.
Thank you in advance.0 -
Thank you for reaching out to us.
For the first question, please refer to the answer on this discussion.
For the second question, if the client uses the COM APIs for use in Microsoft Office library in the VBA code, the code will not work on Workspace because Workspace doesn't support the COM APIs for use in Microsoft Office.
0 -
I'm having a similar issues: native Excel functions respond normally to my F9 (or Shift+F9) commands, but Workspace functions only refresh if I use the ribbon and then select one of the refresh options (Workbook, Worksheet, Selection..). This is far from ideal.
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
- 684 Datastream
- 1.4K DSS
- 615 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
- 249 ETA
- 554 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
- 3 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.9K Refinitiv Data Platform
- 643 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
- 192 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛