I'm pretty used to using the Workflow Configuration -> Events tab to fire a .bat file to run at the end of a module.
But what if I want to run the same bat file halfway through the module? I tried the Run Command, and pointed it towards my bat file, but the tool errors because it complains about needing inputs and outputs. I got confused and gave up. A lot of stuff in Alteryx is obvious, intuitive and clear. The Run command, alas, is not.
So how do I fire up a bat file within a module in the same way that you would if you put it in the Events tab?
My bat file is super simple, and just calls a vbs file, which in turn calls an Excel macro.
Here is the bat file:
@echo off C:\Windows\SysWOW64\cmd.exe /c cscript "C:\Temp\script.vbs"
And here is the vbs file called above. I realise it's a bit roundabout going from bat file -> vbs -> Excel macro, but it works, and for me that's all that matters.
Option Explicit On Error Resume Next ExcelMacroExample Sub ExcelMacroExample() Dim xlApp Dim xlBook Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Open("C:\Temp\Workbook.xlsm", 0, True) xlApp.Run "Macro1" xlApp.Quit Set xlBook = Nothing Set xlApp = Nothing End Sub
So my question is really why can't I just plug my bat file into the Run Command in the same way that I can run it from the Events tab?
Thanks!
Solved! Go to Solution.
@JohnTdata I feel your pain. Wherever you want to insert your run command, I would connect that path to the run command tool, and then setup your run command tool to just output to %TEMP%dummyfile.yxdb. then you can input your bat file in the command section of the run command tool. Then I would setup your read results section of the run command tool to read that same dummy file.
Can we do something similar for vbs files. I have never got cscript to work on server.always get an error 1.