Forum Discussion
How to send cell value as SOAP request in Excel?
IngeborgHawighorst Hi, thank you for your reply! My apologies if my original request wasn't very clear. What I have is a spreadsheet where each row has information about an object, and I need to send that data as a SOAP request through an API.
Each row is concatenated so that the complete SOAP request is in Column W. All I need to do is to have a VBA solution for sending that SOAP request, and if possible (but not essential), recording the SOAP response in Column X.
Ideally I would like to send all the SOAP requests in the spreadsheet in one VBA script, but I will also settle for having a way to send each SOAP request individually if that's the way it has to be done.
Thank you!
Do you need help with sending the SOAP request or with looping through the values in the sheet? If you have almost no knowledge of VBA, then that is not the easiest project to begin with. Have you had a look at the code that you can find with the search I mentioned above? It definitely won't be any easier than these code examples.
IngeborgHawighorst I need help with both, to be honest. I have looked at the code you suggested, and I'm still confused - you're right that this probably isn't the easiest place to start with VBA!
Would you be able to advise on a 'relatively simple' script that I could use to send an individual SOAP request please? It only needs to take the value of a cell in Column W, which is the fully-formed SOAP request, and just send that. Ideally it would be great if I can capture the response too, but I'm ok with not doing that if it's going to prove overly-complicated.
Thank you!