must install a free SOAPWeb services toolkit so
must install a free SOAPWeb services toolkit so that Microsoft Office can generate the SOAPand otherfiles for you. You also need to download the latest version of MSXML, Microsoft s XMLparser. If youjust want to call a Web API using HTTP/GET (REST) or HTTP/POST, then you install MSXMLif it is notalready installed. You learned in Chapter 1 that the party offering the Web API specifies which of theseprotocols the Web API will support. Let s look at an example of how each of these works. Calling Web APIs Using VBA with HTTP/POSTandHTTP/GET (REST) You do not need to install the Web Services Toolkit for Office if you are not calling a Web API usingSOAP. You can use VBAcode to communicate using HTTPPOST and/or GET (REST). Let s look at abasic example of how this works from Microsoft Excel. Example Calling Amazon.com from Excel Using VBA and HTTP/GET (REST) In this example, you call the Amazon.com API discussed in Chapter 4 from Microsoft Excel. Open Exceland create a new workbook called VBATestFromExcel. On Sheet1 of the workbook, arrange the fields asshown in Figure 9-1. It is important that the cells be laid out exactly as shown in the figure if you wantthe results to be displayed in the correct cells. Use the Visual Basic toolbar to add a button in cell B2 asshown. To view the Visual Basic toolbar, select View.Toolbars.Visual Basic. Figure 9-1194Chapter
Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost Adult Web Hosting services