Automating data entry and running an excel macro iteratively

In Alteryx is it possible to automate an excel vba macro, where currently one has to manually update the various cells on the input tab, then press the run button...currently needing to click on it! then the results can hopefully be copied from the relevant cells and brought back into Alteryx to create central spreadsheet or database file from which a merge to a document could then take place? doing this manually case by case is soul destroying and i'm really hoping Alteryx can help, if anyone may have any high level basic template ideas on how it could possibly be achieved? thank you

Tips and Tricks

Macros

Batch Macro

Help

Run Command

Iterative Macro

Accepted answers

TimothyH

@Alex_H I think the majority of it can be accomplished but you would need to use the Run Command tool, which some organizations don't allow on Server. I think in this case you could use Control Containers to first update the various cells, then use the Run Command to kick off the vba (https://knowledge.alteryx.com/index/s/article/Alteryx-Run-Command-Executing-Excel-Macros-VBA-1583461565312), then inputting that result to then write back to your DB or central spreadsheet.

All comments

TimothyH

flying008

Hi, @Alex_H

Most of the operations you mentioned can be implemented in the Run Command tool using like PowerShell code. If you want to run a VBA macro, the premise is that your macro code is not protected or access is prohibited, and your Module is Public rather than private, and there is no need to interact again.

Aa38263

Good ty

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703