I have dataset in my project called abc_stacked, I have Macro file called xyz.xlsm which has Macro enabled, please let me know how to run macro on dataset in project?
Hi @sweet_shyam2001 ,
While you can probably execute a macro through Python, see here for some hints, it will require to have Excel as an application installed on the machine this is being executed.
In the context of DSS, I would suggest rewriting the logic from VBA into a Python recipe. This will help you in keeping things transparent since, even if you managed to execute the VBA itself, it would be on a hidden layer from anything else in your project.
I hope this helps!