Another way you can call Web APIs from Microsoft Office is by calling a .NET program from Office. To call a .NET program from Office, you need Visual Studio .NET 2003, as well as the Visual Studio Tools for the Microsoft Office System program. Both of these are available for purchase from Microsoft, and you can find more information on Microsoft's Web site.
Visual Studio Tools for Microsoft Office basically allows you to use the Visual Studio .NET interface to create code that gets called from Microsoft Office documents. You can use the same code and familiar interface as you do with Visual Studio .NET, and you can also run those procedures from a particular document or spreadsheet. This means that you can call a Web API using SOAP or HTTP with nearly the same code as described in the earlier chapters.
Was this article helpful?