Run VBA code on Alteryx Server

[harsha384]

Hi All,

I have been trying to run VBA code (to execute 2 other excel files) on the Alteryx server which unfortunately doesn't run.  But, the same code runs fine on the local designer. Any idea? or has anyone tried executing the same?

Thanks,

Harsh

[RishiK]

@harsha384 what is the error that you're getting?

This might be purely a permissions issue from the Alteryx Server account.

@BenMoss wrote a good blog about executing vba scripts in Alteryx, this might help you from a Best Practise point of view:
https://www.theinformationlab.co.uk/2020/04/14/triggering-excel-macros-from-the-comfort-of-your-alte...

[harsha384]

Hi @RishiK ,

What kind of permission issue can it be? can you please explain?

Also, there is no error as such. It's just not executing the macro.  i tried running the code given in the link but somehow its giving error "800A03EC" while executing the script

[TheOC · Accepted solution]

hey @harsha384 

If you are running workflows on the Alteryx Gallery, they are running as an 'AlteryxService' user, instead of an administrator user. If this service user does not have permission to run vba, or access the files used in your vba, this may explain the error.

You may need to set the workflow to run as:
https://help.alteryx.com/server/2018.2/admin/Configuration/RunasPermissions.htm?TocPath=Administer%7...

Hope this helps,
TheOC

[Jeff_Neklason]

Great read. Thank you!

[psubramanian]

Hi @harsha384 

Any luck getting to work on the server?