Execution of VBA using Alteryx

Question

Hi Alteryx Community,

I am replicating two excel output sheet that was previously using coding languages. Now, I have to also replicate the VBA function of the current excel sheet but replicating the VBA coding in Alteryx would takes months as the VBA coding is very complicated. Basically, the VBA uses the two excel output that I have replicated to generate a lot of different reports. I would like to inquire is there a way that I can use the current two excel outputs and execute my written VBA without manually needing to manually activating the VBA by opening the excel spreadsheet?

Hope to get more insights from the community regarding this matter. Thank you.

sisecoy347 · Answer

Ty

caltang · Answer

I know you're looking to run it as is, but for the longer term, it is worth investing the time to convert the VBA scripts into Alteryx. It is more robust and documentation on the workflow will be worthwhile.

If you have trouble, don't boil the ocean - try small chunks at a time. A good way to start the re-engineering process is to breakdown the whole VBA and understand what it is trying to do, and go from there by dissecting the code. If you'd like, you can contact me. I've done a lot of re-engineering and written something here some time ago: https://community.alteryx.com/t5/Engine-Works/Tips-for-Reverse-Engineering-Current-Processes-in-Alteryx/ba-p/1148895

Qiu · Answer

@JYLim 
I hope this one will help.
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Running-Excel-Macro-VBA-Script-through-Run-Command/td-p/1254636