run vba macro from groovy

twozedz

You can only run macro using DotNet application or VbScript.

To run a Macro create a DotNet or a VBscript application, invoke it through groovy script.

create an command line exe using Dotnet. 

=======Dot net code======

App = new Excel.ApplicationClass()

object oMissing = System.Reflection.Missing.Value;

WorkBook = App.Workbooks.Open(
"your path", oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing
);

App.Run("MacroName", arg1, arg2 , arg3, arg4)

=====================================

Execute the exe using Groovy script.

Groovy:

def cmd = exePath

def process = "$cmd".execute();

process.waitFor();