Hi community,
I am running into problems with executing VBA code to trigger macro directly in Alteryx. The discussion is extended based on this article
The thing is I wanna automate my input file path by using direct dynamic input from Alteryx without having to change path in the .vbs code everytime. Below is extracted from the suggested code in the article that I wanna replaced by dynamic input in Alteryx.
workbook_path = ".\VBA_Example.xlsm"
Is there anyway to modify and link it to Alteryx without entering/modifying file path in the code? I have tried the [Input] field in the Run Command but no use. Below I attached the package of the run in the article that I have mentioned.
Many thanks for your help and support, that means a lot to me!
