How to run a vba macro( protected by password) in Alteryx

Question

Hello, I would like to ask if there is any way to run a vba macro(protected by password, because there are the credentials from the database), in this workbook the user must input two dates(from - to). I would like to run this code in alteryx and input these dates in alteryx as well. Really appreciate if anyone can help me on it. Thanks!!

CharlieS · Accepted Answer

Hi @andressaolisi

One answer would be to rebuild that VBA process in Alteryx since it's better 😛😛

A more direct answer would be that you'll need to use Run Command to call an external programs like wscript.exe to execute that VBA/VBS. Here's a post that should be helpful with the details of that:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Call-VBA-macro-from-Alteryx/td-p/46062/highlight/false