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
sorry, this forum is a waste of time. i hardly get any response and when i do get a response it is worthless
at work i will make sure we dump soap ui for good. waste of money
Hello,
Sorry that you're disappointed, but asking a question in the forums is not the best way to get support.
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.
Kind regards,
Manne, Ready! API developer
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.
