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

    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 provide such a service, but I can't locate the exact link.

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


  • User profile image

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

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

    Still working on it...


  • User profile image
    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