Calling Web Services within Microsoft Office via the SOAP protocol in the year 2013

A bubble by Jeff Kubina is licensed under Creative Commons | Attribution-Share Alike 2.0 Generic

In the early to mid-2000s Microsoft Corp. painted the world a beautiful picture of the ease at which one could exchange information across disparate systems, whether across the LAN or across the Internet.  The company simultaneously eased both Office users and professional developers into unfamiliar terminology like Web Services, Simple Object Access Protocol (SOAP), and XML.

Don’t worry about the new terminology, Microsoft told Office users (paraphrased).  With a few drag-and-drops and mouse clicks, we made it simple for you to call a web service with little to no coding experience.  You’re going to love how easy it is to push and pull data using Visual Basic for Applications (VBA) within your Office files—namely Excel (paraphrased).

Continue reading Calling Web Services within Microsoft Office via the SOAP protocol in the year 2013