Run Macro xlsm file on Dataset

sweet_shyam2001
Level 1
Run Macro xlsm file on Dataset

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?

0 Kudos
4 Replies
Clรฉment_Stenac

Hi,

Unfortunately, to our knowledge, there is no way to run Excel macros on Unix (and hence within DSS)

0 Kudos
sweet_shyam2001
Level 1
Author

Hi,

Any other way to run VBA code? I mean using Python, R or Shell script language.

Thanks.

0 Kudos
Liev
Dataiker Alumni

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!

0 Kudos
avrama03
Level 1

Hi everyone,

Any updates on this? Are xlsm files still not supported? I am using v12

0 Kudos