Nirbhay Sharma
New Member
Hi All,
I want to implement a macro, that can run a SOAP statement (present in the file itself), and send the values present in the excel file to a particular system.
Let me break it down for you:
1) there is an excel file with data on something...say Sales Calls made by a Sales Rep
2) there is a pre-tested SOAP statement that will be used to load the data inside the excel using a webservice and a username password authentication, and one by one run the soap statement for all the records.
I am new to SOAP but managed to learn it enough to get a SOAP request running for a record manually in SOAP UI. Now it needs to be automated using excel VBA macros. Any help would be welcome. Even a basic structure or a different example of a SOAP running thru a macro dynamically picking values from excel cells, it would be great as i can extend it.
Plz have a look at the sample.
Thanks in advance
I want to implement a macro, that can run a SOAP statement (present in the file itself), and send the values present in the excel file to a particular system.
Let me break it down for you:
1) there is an excel file with data on something...say Sales Calls made by a Sales Rep
2) there is a pre-tested SOAP statement that will be used to load the data inside the excel using a webservice and a username password authentication, and one by one run the soap statement for all the records.
I am new to SOAP but managed to learn it enough to get a SOAP request running for a record manually in SOAP UI. Now it needs to be automated using excel VBA macros. Any help would be welcome. Even a basic structure or a different example of a SOAP running thru a macro dynamically picking values from excel cells, it would be great as i can extend it.
Plz have a look at the sample.
Thanks in advance