How to programmatically check in Excel/VBA which Excel add-in (Eikon or WS) is loaded?

Michal_Antoniak
Michal_Antoniak LSEG
edited May 19 in Eikon COM

Hello Team,

Is there a way to programmatically check in Excel/VBA which Excel add-in version (Eikon or Workspace) is loaded in a given instance of excel? This would streamline the process of Eikon/WS verification for number of users at clients' side.

I got below function earlier, but it just displays generic description.

Application.COMAddIns.Item("PowerlinkCOMAddin.COMAddin").Description

Thank you!

Tagged:

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Michal_Antoniak

    Thank you for reaching out to us.

    Please check this discussion.

    As far a I know, the Workspace Excel Addins will not be loaded properly when an Excel is started from a script.

    I checked and found that the product team doesn't support this kind of usage. You may need to raise a feedback to the product team to support this feature in the LSEG Workspace Excel via the Feedback page. Otherwise, please contact the product support team directly to support this kind of usage.

Categories