Having VBA Scripts as input for the flow.

Question

Hello Everyone,

In one of the use cases that I am currently working on, the first step is to run VBA scripts which give the excel files which are the input data for the workflow. I am new to Alteryx. I referred to a few examples but they were a bit different from what I need. So if possible, can anyone please show me an example workflow on how to do it, if possible?

Luke_C · Answer

Hi @varun_sub

What you could try is creating a .bat file that runs this vb script. I provided the syntax in my original reply. Then, in the events pane browse for that .bat file and set it to run 'before run' so it executes before the workflow starts. The events menu is accessible via the workflow configuration panel. Click Add and then populate the pop-up shown below. You should only need to input the filepath of the bat file. The article @BrandonB posted also has a lot of great info. I've only done this on the output side of a workflow but this should get you something to work with, unfortunately I don't have access to whatever your vb script is trying to do, seems like an interesting challenge.

varun_sub · Answer

@Luke_C Hello Luke, I have attached the input vbs script file as a txt file since it doesn't allow it. The output would be csv files which needs to be uploaded to s3 bucket. I tried many things and it still throwing an error. Can you please send me a workflow doing the above?

Regards,

Varun

ALL-IN.txt

BrandonB · Answer

This is one of the best articles I have found for running VBA https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel-Macros-VBA/ta-p/471551

It walks you through the process step by step