Alteryx Designer

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

Run VB script or Batch file Remotely from Alteryx

Highlighted
7 - Meteor

Hi,

 

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")

 
objExcel.Application.Quit
set objExcel = Nothing
set objWorkbook = Nothing

 

Capture.PNGCapture2.PNG

 

 

 

 

 

Labels