Calling a webservice from Excel

[Hani]

Where can I find sample codes for both excel 2002 and 2003 for
retrieving data (SQL Data) from a web service.

Thank you

H

 

[Dino Chiesa [Microsoft]]

http://www.google.com/search?num=30...TF-8&oe=UTF-8&q="office+web+services+toolkit"
-Dino

 

[Ian Jones]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxpwst/html/odc_ofwsrt.asp


I've also used the MSXML XMLHTTP COM component in VBA to call web services
with great success!

http://msdn.microsoft.com/library/d...ry/en-us/xmlsdk30/htm/xmobjxmlhttprequest.asp

HTH

Ian