使用Excel 2010中的VBA代码调用Web服务 [英] calling web service using VBA code in excel 2010

问题描述

我正在Excel 2010中编写一些将使用Web服务的VBA代码。我无法在互联网上找到相关资源。有人可以告诉我如何做到这一点。

I am trying to write some VBA code in Excel 2010 that would consume a web service. I am unable to find any related resources on the internet. Can someone please tell me how to do this.

推荐答案

我不认为标题为答案的帖子是对的 - 指向基于MS Office Web Services Toolkit的Excel 2003解决方案的链接。该解决方案不再有效，因为工具包不再受支持。请参阅： MSDN - 在Excel 2007中使用Web服务。该链接为Excel 2007提供了可以转换到Excel 2010的解决方案。您将需要具有Microsoft Office Developers Tools的Visual Studio 2010。它也意味着在C＃或VB.NET中使用.Net框架和编码。

I don't think the post marked as the answer is right - it links to the Excel 2003 solution, which was based on the MS Office Web Services Toolkit. That solution is no longer valid as the Toolkit is not supported any more. See: MSDN - Consuming Web Services in Excel 2007. The link provides a solution for Excel 2007 which can be transposed to Excel 2010. You will need Visual Studio 2010 with Microsoft Office Developers Tools though. It also means utilising .Net Framework and coding in C# or VB.NET.

这篇关于使用Excel 2010中的VBA代码调用Web服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！