Question on Excel Macros

Morzanapy

Hello the Live Chat couldn't answer my question and referred me to this Forum.

It regards to Excel which, to my amazement, is not included in the "Select a category" menu above.

I have a macro that calls 10 RICs, one after the other in a loop, downloads the same basic data for each RIC, copy paste the results in another part of the macro and does the same for the next RIc until the 10 Rics are done.

The problems lies in the fact that the macro performs too fast and doesn't leave enough time between each Ric to download/refresh the information before copying the data.

I tries to introduce a line "Application.wait" for 10 seconds to give it time but it changes nothing.

My question is two fold:

• is there a VBA command specifically for Excel Workspace that allows to pause a macro meanwhile Workpsace downloads/refreshes data before continuing ?
• is there a list of all VBA commands that pertains to Workspace that can be consulted somewhere on the Refinitv site ?

I do not know if any users member of this community has ever encountered this issue but I am hoping someone can answer me.

Thank you in advance.

Jirapongse

@Morzanapy

Thank you for reaching out to us.

I found that you have submitted this issue to the support team.

As far as I know, the Workspace Excel provides macros to refresh data, as mentioned on this discussion.

I have contacted the case owner to reopen the case and escalate it to the Workspace Excel team to answer the following questions.

• is there a VBA command specifically for Excel Workspace that allows to pause a macro meanwhile Workpsace downloads/refreshes data before continuing ?
• is there a list of all VBA commands that pertains to Workspace that can be consulted somewhere on the Refinitv site ?

Otherwise, I may need to submit this issue to the Workspace Excel support team on your behalf.

For now, please share the excel file or code that you are using. Therefore, we will know the functions or macros that you are using.