Can you please help in creating VBA code for the below:

Norland

What I need is VBA code to:

• Check whether Workspace COM add in is loaded, and load it if not
• Check Workspace status (online, offline, refreshing, paused) and trigger log in and refreshes
• Retrieve FX spot live, today’s high, today’s low as well as fixrates (WMRH etc) and the corresponding timestamps
  EIKON VBA code.txt

  EIKON VBA code.txt

  Uploaded May 20, 202516.45 KB

Jirapongse

@Norland

Thank you for reaching out to us.

Typically, this forum doesn't provide the coding service. Please check with the Workspace Excel Add-ins product team to find out which macros are available for use in VBA.

Moreover, you can refer to the answer on this discussion.