Well this part is more art than science. Hopefully, in the post request, you can see the breakdown of the request to know what you should send in. Usually, the values are in the URL or in the payload. Alternatively, if you are familiar with the system you are requesting information from, there may be an API that explains exactly what's required in the request. If it's SOAP, that means the response is going to come back as XML. This is good news because you can scrape the XML response as you would HTML (indeed, arguably you can scrape it more easily).

The problem is, SOAP requests are a little old. Here are a few conversations about it, i've found:

http://community.spiceworks.com/topi...a-vba-in-excel
http://scn.sap.com/community/epm/blo...ustom-vba-code
http://www.soapuser.com/client4.html

But outside of that, I couldn't give you any sample code.