Run Command CScript to run Macro works in designer but not in gallery/server

[wonka1234]

Hi,

When I run my runcommand locally it works fine, even in the gallery it runs as "success", however I do not see the change reflected from the CScript / VBS  script when ran on the server.

When run locally I see the vbs script actually being executed.

Anyone have any advice on it?

all the script is doing is opening an excel file, runing a macro and saving it. 

The server does have access to the path where it is stored.

[BrandonB]

I would take a look at this thread, as it may help with your problem: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Run-as-command-not-working-wit... 

Also, do you know if the Run As user on the Alteryx Server has access to the folder containing CScript on the Server? 

[danilang]

Hi @wonka1234 

Another thing to look at is whether Excel is actually installed on the server.  Vbscript commands attempt to launch excel on the server and if excel is not installed the script may not execute. 

NOTE:  MS does not recommend running office applications in unattended mode, such as when run on the Alteryx server

Dan