Facing issue on SFIL global

Vaishu_1329
edited April 17 in Eikon COM

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.

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Kunal

    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.

  • Emil
    Emil Newcomer

    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.