Alteryx Designer

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

Run VB script or Batch file Remotely from Alteryx

7 - Meteor



I'm having a issue#1 with VB script execution, in my current workflow trying to exec vb-script file remotely, I tried using in 'Event' and as well as using Run Command tool but getting same error. I also used wscript.exe and cscript.exe but no luck.


Issue#2 with Batch file, tried to open(execute) batch file remotely but not working.


If I open .VBS file directly or If I run batch file directly from original server both working fine, it creating a another csv file and that I want but, I want to open (execute) this .vbs file withing Alteryx workflow.


Batch file script:

@Echo off
set excel_program=C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
set xlsb_files=C:\absdata\template


cd "%xlsb_files%"
start "%xlsb_files%" "abc.xlsb"


VB script:

Dim objExcel
Dim objWorkbook

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook = objExcel.Workbooks.Open("\\Host\c$\absdata\template\abc.xlsb")

set objExcel = Nothing
set objWorkbook = Nothing