使用VBA创建Excel 2007或2010自定义任务窗格 [英] Create Excel 2007 or 2010 custom task pane using VBA

问题描述

可以为 Excel 2007或2010 为 Visual Studio 创建一个自定义任务窗格，仅使用 VBA ？

Is it possible to build a Custom Task Pane for Excel 2007 or 2010 without Visual Studio, that is, using only VBA?

我发现这个其他的问题，但是它并不适用于我。

I found this other question but it's not working for me.

推荐答案

到目前为止，您的问题的答案是否。

I think, as of now, the answer to your question is "No".

据我所知，扩展任何Office应用程序（Excel，PowerPoint等）自定义任务窗格/应用程序窗格需要COM加载项，需要使用Visual Studio进行开发。

As far as I can tell, extending any Office application (Excel, PowerPoint, etc.) with a Custom Task Pane / Application Pane requires a COM add-in, that needs to be developed with Visual Studio.

至少对于Office 2007，本文（ https://msdn.microsoft.com/en-us/库/ aa338197％28v = office.12％29.aspx ）具体说明：

At least for Office 2007, this article (https://msdn.microsoft.com/en-us/library/aa338197%28v=office.12%29.aspx) specifically states that:

（..）自定义任务窗格部署为组件对象模型（COM）
加载项（..）

(..) custom task panes are deployed as Component Object Model (COM) add-ins (..)

同一篇文章说VBA不支持创建su ch自定义任务窗格。

The same article states that VBA does not support creating such custom task panes.

您可以使用支持COM和
的任何语言创建自定义任务窗格，使您能够创建动态链接库（DLL）文件，用于
示例，Microsoft Visual Basic 6.0，Microsoft Visual Basic .NET，
Microsoft Visual C ++，Microsoft Visual C ++ .NET和Microsoft Visual
C. 但是，Microsoft Visual Basic for Applications（VBA）不支持创建自定义任务窗格。自定义任务窗格使用您已经熟悉的其他
技术，例如
Microsoft ActiveX控件。

You can create custom task panes in any language that supports COM and that enables you to create dynamic-linked library (DLL) files, for example, Microsoft Visual Basic 6.0, Microsoft Visual Basic .NET, Microsoft Visual C++, Microsoft Visual C++ .NET, and Microsoft Visual C. However, Microsoft Visual Basic for Applications (VBA) does not support creating custom task panes. Custom task panes use other technologies with which you are already familiar, for example, Microsoft ActiveX controls.

本文介绍如何使用VS2013中的C＃或VB创建自定义任务窗格： https://msdn.microsoft.com/en-us/library/aa942846.aspx

This article shows how to create a custom task pane with C# or VB in VS2013: https://msdn.microsoft.com/en-us/library/aa942846.aspx

总而言之，本文（ https://msdn.microsoft.com/en-us/library/bb398242.aspx ）声明，您需要Microsoft Office Developer Tools来开发办公室解决方案，该解决方案仅与

All in all, this article (https://msdn.microsoft.com/en-us/library/bb398242.aspx) states that you need Microsoft Office Developer Tools for developing office solutions, which is only bundled with

• Visual Studio Professional


• Visual Studio Premium


• Visual Studio Ultimate
• 
  

• Visual Studio Professional
• Visual Studio Premium
• Visual Studio Ultimate

如果您只有VBA可用，您似乎现在仍然停留在原来的用户表单中。

If you only have VBA available it seems like your are stuck with the original User Forms for now.

这篇关于使用VBA创建Excel 2007或2010自定义任务窗格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！