在 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.

推荐答案

我不认为标记为答案的帖子是正确的 - 它链接到 Excel 2003 解决方案，该解决方案基于 MS Office Web 服务工具包.该解决方案不再有效，因为不再支持 Toolkit.请参阅:MSDN - 在 Excel 2007 中使用 Web 服务.该链接提供了 Excel 2007 的解决方案，该解决方案可以转换为 Excel 2010.不过，您将需要带有 Microsoft Office 开发人员工具的 Visual Studio 2010.这也意味着使用 .Net Framework 并使用 C# 或 VB.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屋！