run vba macro from groovy

Question

Hi I have Soap UI pro at work and &nbsp;i am wondering whether the following can be automated:&nbsp;1) Submit a request in soapui pro. A response is successfully received. This step does'nt need to be automated. I will manually run this.&nbsp;3) Run a vba macro from groovy. The macro's inputs are request and response files from step 1 and also 2&nbsp;other excel files saved locally.&nbsp;&nbsp;2) Copy calculated data generated from macro back into soap ui and show it to the user in a nice looking report.&nbsp;&nbsp;

prashobkt · Answer

twozedz&nbsp;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.&nbsp;create an command line exe using Dotnet.&nbsp;=======Dot net code======App = new&nbsp;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)&nbsp;=====================================&nbsp;Execute the exe using Groovy script.&nbsp;Groovy:&nbsp;def cmd = exePathdef process = "$cmd".execute();&nbsp;process.waitFor();&nbsp;&nbsp;&nbsp;

twozedz · Answer

sorry, this forum is a waste of time. i hardly get any response and when i do get a response it is&nbsp;worthless&nbsp;at work i will&nbsp;make sure we dump soap ui for good. waste of money

mfagerlind · Answer

Hello,
&nbsp;
Sorry that you're disappointed, but asking a question in the forums is not the best way to get support.
&nbsp;
If you have a SoapUI Pro license, you're entitled to support, so you should open a ticket with Customer care. They will help you, and if they can't they'll reach out to us, the developers.
&nbsp;
Kind regards,
Manne, Ready! API developer

twozedz · Answer

thanks. finally get a response.&nbsp;do you know how i can display worksheet results from macro in soap ui pro?&nbsp;this is what i am trying to do:&nbsp;1) submit request and receive response using soapui pro and save files to local drive - DONE2) &nbsp;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!!!!!&nbsp;3) now i need to see results of macro in sheet displayed in soap ui... &nbsp;Not sure how to this.Any suggestions?? the results&nbsp;from macro in the excel sheet is nicely formatted and is in table format with proper headers.&nbsp;&nbsp;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.

prashobkt · Answer

twozedz&nbsp;It will be better to &nbsp;write a Groovy script for reading the file using Apache POI library (Already in Lib directory of SoapUI).&nbsp;OR&nbsp;&nbsp;Incase of single value to be seen, change the return type of main in DotNet program and macro in excel to integer type.&nbsp;You can get the return value using below groovy script.&nbsp;def exitCode = process.exitValue();

Forum Discussion

run vba macro from groovy

Related Content

Looking for a macros for test case status

Execute MS Excel Macro from TestComplete script

groovy script errors

Execute VBA Excel Macro from TestComplete Script

Parse a JSON Response Using Groovy

Recent Discussions

Accessing database connection string from groovy test step

Assert Step Not Executing All Assertions

Include external files (XML) for JDBC connection

JDBC database connection pooling

JDBC "Some connection settings are not specified"