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.