Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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,
Unfortunately, to our knowledge, there is no way to run Excel macros on Unix (and hence within DSS)
Hi,
Any other way to run VBA code? I mean using Python, R or Shell script language.
Thanks.
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!
Hi everyone,
Any updates on this? Are xlsm files still not supported? I am using v12