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
20 - Arcturus
20 - Arcturus

@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