Try your hand at analyzing royal sentiment in Dataiku DSS! Learn more

Run Macro xlsm file on Dataset

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
3 Replies
Dataiker
Dataiker

Hi,

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

0 Kudos

Hi,

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

Thanks.

0 Kudos

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