ExcelCommand "Recalculate workbook"

[lrobin]

Hello,

I get this message when I run “ExcelCommand “Recalculate workbook”” from serveur, not from my local EasyMorph. Any idea ?
(Excel is installed on the serveur)

I’am not sure but with this fucntion i would like to recalculate TCD after updating data, may it is not the right method for that.

La récupération de la fabrique de classes COM pour le composant avec le CLSID {00024500-0000-0000-C000-000000000046} a échoué en raison de l’erreur suivante : 80070005 Accès refusé. (Exception de HRESULT : 0x80070005 (E_ACCESSDENIED)).

Location: action “Excel command”, table “Table 1 (2)”

[andrew.rybka]

Hello @lrobin,

Please refer to the following chapter for possible solutions for this error:

Running VBA Macros from the Excel Command action

With the release of EasyMorph version 5 comes an amazing new action called Excel Command which allows for running precreated Excel macros – subroutines or functions – from with a workflow, using the “Run VBA macro” setting. This option opens up new potentials for processes outside the scope of EasyMorph like applying complex formatting, inserting or formatting objects (charts, pivottables, shapes, etc.), or triggering an Excel-based reporting process. The sky’s the limit when you can have a co…