我是否可以在添加时定义相同的UDF？ [英] Can I define the same UDF in more than on add in?

问题描述

您好，

                
我为不同的用户创建了各种不同用途的插件。我希望能够在多个添加中定义一些用户定义的功能，以便在用户安装了任何的任何时它们将起作用。
这可能吗？如果 有两个名称相同且结果相同的UDF在两个添加项中如果有人同时添加了ins，它们是否会正常工作？或者他们是否需要在不同的插件中使用不同的名称？

                I create add ins for various different purposes for different users. I would like to be able to have some User Defined Functions that are defined in more than one add in so that they will work if a user has any of those add in installed. Is that possible? If  there are UDFs with the same name and same results in two add ins will they work correctly if someone has both add ins installed? Or do they need to have different names in different add ins?

谢谢，

Ethan Strauss

Ethan Strauss

推荐答案

Hello Ethan，

Hello Ethan,

我在两个自动化加载项中创建了一个同名的UDF。如果我安装两个加载项，它工作正常。您可以从 https://code.msdn.microsoft.com/office/CSExcelAutomationAddIn-下载示例自动化加载项。 c46f6956 ，
创建一个类似的并进行测试。如果它不适合你，请告诉我。

I create a UDF with the same name in the two automation add-ins. It works fine if i install both add-ins. You may download sample automation add-in from https://code.msdn.microsoft.com/office/CSExcelAutomationAddIn-c46f6956, create a similar one and have a test. If it does not work for you, please let me know.

问候，

Celeste

这篇关于我是否可以在添加时定义相同的UDF？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！