We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog 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

4 REPLIES 4
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
12 - Quasar

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
6 - Meteoroid

Great read. Thank you!