Run a SOAP statement using a VBA macro to import data

nirbhaysharma

New Member
Joined
Aug 31, 2015
Messages
1
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.


This will be the settings sheet in the excel file:
###USERNAME###sample_user
###PASSWORD###sample_password
SOAP STATEMENTsoap_statement

<tbody>
</tbody>

This will be the data file:
###ACCOUNTNAME######CONTACTNAME######SUBJECT######ALIAS######TYPE###
Account1Contact1Subject1Alias1Type1
Account2Contact2Subject2Alias2Type2
Account3Contact3Subject3Alias3Type3
Account4Contact4Subject4Alias4Type4
Account5Contact5Subject5Alias5Type5

<tbody>
</tbody>

What the macro should do is pick up the data from each row, put it in the soap statement and then run the statement to insert the data into the crm system.

Due to some reason i am unable to paste the SOAP statement here. hence i am giving a link to its snapshot. still, any ideas on how to paste it here?

snapshot of soap statement:

thanks in advance :)
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

BartOon

New Member
Joined
Mar 1, 2016
Messages
2
Hello,

So nothing about during this six next months ?
To many post over the web without any answer only thread started but not closed with a solution.

UP !
 

Watch MrExcel Video

Forum statistics

Threads
1,123,198
Messages
5,600,280
Members
414,374
Latest member
akbir

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top