Hi,
I thought i'd post this example because I recently had to do this for a project but most of the MS documentation relates to the EightBall webservice on the now defunct GotDotNet site.
I'm not sure if it will work or not unless you download the Web Services 2.0 toolkit which includes the correct SOAP references.
Most of the code is created automatically by the toolkit so if you want to run through it's creation yourself, once the toolkit is installed go to Tools -> Web Service References in the VBA window and point it to this web service URL
http://swanandmokashi.com/HomePage/WebServices/QuoteOfTheDay.asmx?WSDL
click on search and then add the service and it will generate all the class modules necessary and then it is very simple to call the GetQuote function.
Only a few more steps from here to incorporate more interesting web services like Amazon/Google etc.
Have fun!
Tom
I thought i'd post this example because I recently had to do this for a project but most of the MS documentation relates to the EightBall webservice on the now defunct GotDotNet site.
I'm not sure if it will work or not unless you download the Web Services 2.0 toolkit which includes the correct SOAP references.
Most of the code is created automatically by the toolkit so if you want to run through it's creation yourself, once the toolkit is installed go to Tools -> Web Service References in the VBA window and point it to this web service URL
http://swanandmokashi.com/HomePage/WebServices/QuoteOfTheDay.asmx?WSDL
click on search and then add the service and it will generate all the class modules necessary and then it is very simple to call the GetQuote function.
Only a few more steps from here to incorporate more interesting web services like Amazon/Google etc.
Have fun!
Tom
