Alteryx Manual Task

[AndrewSarantakis]

Hey everyone,

I have a repeatable nightly task and was wondering if anyone had some tips or ideas to help see if Alteryx can fully or partially automate this task.

The workflow is a 3-step process. I'm hoping to start with tackling the first step

step one,

I open a premade excel file with macros coded into the file so the only thing I touch when opening this file is the date I want to run the file on the data it is connected to. After picking the date it runs and saved to the computer driver that I picked to save it in.

My first step would be seeing if there is any tool within Alteryx that can tackle this step?

any help would be very much appreciated!

[ChrisTX]

If Excel can do it, then it's very likely Alteryx can do it.

Do you want to move the Excel macro logic to Alteryx (can you post the Excel file or the macro VBA code), or run the Excel macro from Alteryx?

Chris

[AndrewSarantakis]

hey Chris,

I'm not familiar with the macros on the excel file or how its built so I'm not sure which option would be better, but do you know which tools within the desktop app for Alteryx I can look into to investigate more?

I will try to see what I can provide as far as the file macro so you can look at it more as well, more to come on that.

[ChrisTX]

If you're asking about running an Excel macro from Alteryx, check out:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/xls-macro-in-alteryx/td-p/315169

Please see this article:

https://stackoverflow.com/questions/2050505/way-to-run-excel-macros-from-command-line-or-batch-file

If you can script this to run on the command line, you can have alteryx execute the macro(s) upon completion of a workflow.

and

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Not-able-to-run-VB-Script-from-Alteryx...

Chris