• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Using Web Services in Excel, ... > The Microsoft Office Web Services To...

9.2. The Microsoft Office Web Services Toolkit

Unlike the rest of the XML functionality in Word, Excel, and Access, if you want to use SOAP-based web services, you'll need to download a separate package, the Microsoft Office Web Services Toolkit. (InfoPath has web services support built into it.) As the URL for this package has changed a few times, it's easiest to go to http://www.microsoft.com/downloads/search.aspx and search for "Office Web Services Toolkit." Separate versions are available for Office XP and Office 2003. Once you've installed it, you'll be able to have Office generate VBA code for accessing and using web services. Microsoft's support for SOAP comes with the toolkit, and has also become part of Windows with Windows XP.

It is possible to create VBA code that accesses SOAP services without using the Toolkit, but doing so requires much greater knowledge of both VBA and SOAP than this chapter assumes. If you're feeling intrepid, see Chapter 8 of Matthew MacDonald's Office 2003 XML for Power Users (APress).



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint