Hi,
so I have a number of workflows that writes to excel, within the excel docs there's formatting to make a nice report and then I would save to PDF and send out.
I want to remove all manual effort and use the run command to kick off an excel macro which updates the data and saves a PDF report. I have created a run command following the example in the below link and all works great on my desk top however when I save this to my gallery and run on the server, Alteryx updates the excel but then hangs.
We have also wrote a powershell script to do the same with an error log that reads:
PS>TerminatingError(New-Object): "Retrieving the COM class factory for component with CLSID {00000000-0000-0000-0000-000000000000} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))."
Would excel need to be installed on the server machine to enable this workflow to complete or am I missing something else?
https://www.theinformationlab.co.uk/2020/04/14/triggering-excel-macros-from-the-comfort-of-your-alteryx-workflow/?unapproved=108727&moderation-hash=d34fd0a465465b2c37f80c7d79cbc83a#comment-108727
