Automating data entry and running an excel macro iteratively

[Alex_H]

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

[TimothyH · Accepted solution]

@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-1583461...), then inputting that result to then write back to your DB or central spreadsheet.  

[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.