Alteryx Manual Task

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!

Workflow

Accepted answers

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-but-running-in-Excel/m-p/999438#M246701

Chris

All comments

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-but-running-in-Excel/m-p/999438#M246701

Chris

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703