How to call Web service in Excel using Visual Studio Tools for Office

Play How to call Web service in Excel using Visual Studio Tools for Office

The Discussion

  • User profile image
    Marak60

    Sorry if I'm missing something, but would it be possible to provide the web service address so that I can run through the application from start to finish?  Or is this a custom web service you've created?  It appears that NOAA and Weather.gov provide such a service, but I can't locate the exact link.

    And please create more videos like this, highlighting the potential of VSTO!

    Thanks!

  • User profile image
    Marak60

    OK, I think this is the weather web service used:

    http://www.webservicex.net/globalweather.asmx?WSDL

    But I still can't figure out how to resolve the "GlobalWeatherSoapClient" object used in the project.

    Still working on it...

     

  • User profile image
    bigbadbau
    If we have a web service that take a long time to run. It makes the spreadsheet not responsive. Is there a command we can use that makes the web service call in the background and make the spreadsheet usable to the user while it is waiting for the response from the web service? I was trying a Application.DoEvents call but it is still making my spreadsheet unresponsive when waiting for a response from a web service. Do you have any advice?

Add Your 2 Cents