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.
@Skapoor1
I usually use the Engine.WorkflowDirectory constant for relative path.
If you can give more details with sample data, we can discuss further.