We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Running xlsm file Run Command Tool

Skapoor1
7 - Meteor

Hi All

 

I am trying to run a .xlsm file from run command tool. The .xlsm file when opened triggers the macro. This macro is a part of the elaborate solution in alteyrx. I tried using the vbs script but could not bypass the company security feature on excel. So as the next best step i want to run the xlsm file directly from alteryx. I want to keep all the paths relative. Is there a way i can do this through run command. The xlsm file resides in a specific folder in the app folder structure and then creates an output.

 

This solution would be used by a lot of people hence the paths/arguments need to be relative.

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@Skapoor1 
I usually use the Engine.WorkflowDirectory constant for relative path.

If you can give more details with sample data, we can discuss further.

Qiu_0-1616411277318.png

 

Labels
Top Solution Authors