topic Re: Run VBA code on Alteryx Server in Alteryx Server Discussions

Run VBA code on Alteryx Server

harsha384 — Wed, 12 May 2021 05:19:07 GMT

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

Re: Run VBA code on Alteryx Server

rkapoor — Wed, 12 May 2021 07:37:02 GMT

@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-alteryx-workflow/

Re: Run VBA code on Alteryx Server

harsha384 — Wed, 12 May 2021 14:27:03 GMT

Hi @rkapoor ,

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

Re: Run VBA code on Alteryx Server

TheOC — Wed, 12 May 2021 16:02:42 GMT

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%7CConfigure%7C_____5

Hope this helps,
TheOC

Re: Run VBA code on Alteryx Server

Jeff_Neklason — Fri, 21 May 2021 16:39:20 GMT

Great read. Thank you!

Re: Run VBA code on Alteryx Server

psubramanian — Tue, 01 Nov 2022 00:39:40 GMT

Hi @harsha384

Any luck getting to work on the server?