Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Run VBA code on Alteryx Server

harsha384
8 - Asteroid

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

5 REPLIES 5
RishiK
Alteryx
Alteryx

@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
8 - Asteroid

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
15 - Aurora
15 - Aurora

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


Bulien
Jeff_Neklason
8 - Asteroid

Great read. Thank you!

psubramanian
7 - Meteor

Hi @harsha384 

Any luck getting to work on the server?