run vba macro from groovy
Hi I have Soap UI pro at work and i am wondering whether the following can be automated: 1) Submit a request in soapui pro. A response is successfully received. This step does'nt need to be auto...
Forum Discussion
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();
thanks. finally get a response.
do you know how i can display worksheet results from macro in soap ui pro?
this is what i am trying to do:
1) submit request and receive response using soapui pro and save files to local drive - DONE
2) using vba macros do some calculations using the request and response files. macro displays results in sheet in excel. DONE as you suggested i ran the step in groovy script. thank you for that!!!!!
3) now i need to see results of macro in sheet displayed in soap ui... Not sure how to this.Any suggestions?? the results from macro in the excel sheet is nicely formatted and is in table format with proper headers.
i will be doing the above for over 100 request files..so i need to be able to see the results in soap ui for each test request.
It will be better to write a Groovy script for reading the file using Apache POI library (Already in Lib directory of SoapUI).
OR
Incase of single value to be seen, change the return type of main in DotNet program and macro in excel to integer type.
You can get the return value using below groovy script.
def exitCode = process.exitValue();