Figure 8-10SummaryIn this chapter, you learned how easy
Calling Web APIs fromMicrosoft OfficeIn Chapter 8, you explored various ways that you can call XMLWeb APIs from mobile devices. Youcan also use XMLWeb APIs to expand the features offered in your solutions written in MicrosoftOffice. This chapter covers various ways you can integrate Web APIs into Microsoft Office programs. Some of these methods require an additional software program or toolkit, whereas others can bedone with just Microsoft Office and VBA. More specifically, this chapter covers the following: .Calling a Web API using VBAand HTTPfrom Microsoft Excel .Installing the SOAPWeb services toolkit for VBA .Calling a Web API using VBAand SOAPfrom Microsoft Excel .Installing Visual Studio Tools for the Microsoft Office System .Calling a Web API using the Visual Studio Tools program and SOAPfrom Microsoft Word Calling Web APIs from VBA CodeVBAis an acronym that stands for Visual Basic for Applications. VBAis a programming languagethat is included as part of several Microsoft products, including Access, Word, and Excel. Forexample, Access 2003 VBAuses VBAversion 6.0, which is the same version of VBAused by Word2003 VBAand Excel 2003 VBA. VBAis a programming language that can be used to incorporateadditional features into your applications. VBAshould not be confused with the Microsoft VisualBasic or Visual Basic .NET programming products. VB and VB.NET each has its own syntax of theVisual Basic programming language. The VB syntax, the VB.NET syntax, and the VBAsyntax arevery similar, but there are also differences between them. You can use VBAto call a Web API from a Microsoft Office program. Depending on the type ofWeb service you want to call, you may need to download one or more additional toolkits in orderfor your call to work. For example, if you want to call a Web service from VBAusing SOAP, you12_
Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Mac Web Hosting services