This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow which checks to see if a status is marked as complete and if so, adds the "date completed" as today's date. After outputting the file I want to run a VB script on this file which calls the macro within the output file to do some basic formatting.
within the "Run command! option i have cscript FormatScript.vbs within the "Run External Program Command" and the output file from above within the "Read Results" and i get the error "When there is an incoming connection this tool requires an output file to be configured"
I have attached the workflow.
As i cant upload the VB script or macro within the output i have saved/attached the output file as a normal workbook and contents of the script and macro can be found below:
VB Script "FormatScript":
Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("C:\Users\jmurray8\Desktop\Consolidated Jobs.xlsm")
I went through the post. I tried replicating your workflow. However, the vbs file runs well without any error when i execute it out of Alteryx. However, when i run the Alteryx workflow i always get the below error:
Please help. I have been struggling to execute vbs script through Alteryx since over 3 days now. But, had no luck.