FC Excel Link API for Macros

[Olga_Vasileva]

Is there a guide or at least an example of using FC Excel Link API for Macros?

Functions like ConnectExcelApp, RefreshWorksheet, ImportWorksheet, ExportWorksheet are of main interest.

[meenubansal87]

Hi Olga,

Please use the EPM Add-in help to needed the information.

Regards,

Meenu

[Olga_Vasileva]

Hi Meenu,

Thank you for replying.

I've tried already following EPM Add-in API as an example (particulary example explained in EPM Add-in Academy - Enterprise Performance Management - SCN Wiki), but Excel Link API must be different as it didn't work.

[meenubansal87]

Hi Olga,

Can you share the screenshot of what is not working.

Regards,

Meenu

[Olga_Vasileva]

Hi Meenu,

I can't give you a screenshot, as there is no error: it doesn't work because it can't be used for FC Excel Link add-in the same way it's used as for EPM Add-in.

For example, in EPM Add-in Academy example mentioned above the following VBA code is used for Refresh button:

     Sub Refresh_on_Click()

     Dim x As New FPMXLClient.EPMAddInAutomation

     x.RefreshActiveSheet

     End Sub

But FPMXLClient is specific for EPM Add-in, I couldn't find its equivalent for FC Excel Link add-in.

So what I am looking for is the example of the same - but for FC Excel Link add-in.