Excel Addin打开 [英] Excel Addin open
问题描述
您好,
我正在使用MS Excel 2010.我在VBA中开发了一个插件作为xlam文件。插件包含超过一百个用户定义的函数(UDF)。在addin的Thisworkbook模块中,我编写了一个Workbook_AddInstall事件过程,其中我在名为"HidroXL"的函数类别中注册了所有
UDF。以及它们的描述和参数。
I'm using MS Excel 2010. I developed an addin in VBA as an xlam file. The addin contains more than a hundred of user defined functions (UDFs). In Thisworkbook module of the addin, I wrote a Workbook_AddInstall event procedure in which I register all of my UDFs in a function category named "HidroXL" along with their descriptions and arguments.
当我安装插件时,我可以看到我的功能在我的自定义"HidroXL"中分类。类别。它工作正常。问题是,当我使用Excel并重新启动它时,我的自定义类别"HidroXL"已经不见了,取而代之的是另一个xll addin的
名称。我尝试将UDF注册码放在Workbook_open和Auto_open子例程中。没有成功。
When I install the addin, I can see my functions categorized in my custom "HidroXL" category. It works fine. The problem is that when I cexit Excel and restart it, my custom category "HidroXL" is gone and replaced by another xll addin's name. I tried putting the UDF registration codes in Workbook_open and Auto_open subroutines. No success.
每次应用程序启动时Excel都会加载已安装的插件文件吗?或者我是否必须为此编写另一个代码,例如在模板工作簿中?
Do Excel loads the installed addin files each time the application starts? Or do I have to write another code for that, for instance in a template workbook?
提前感谢您的帮助。
Selami
推荐答案
m,
re: 开发加载项
可能有帮助的问题...
您是否使用Application.MacroOptions方法分配类别?
是否使用公式从工作表中调用函数 或  由其他职能/潜水员召集?
您是否看过/阅读"使用Excel注册用户定义的函数" Jan Karel Pieterse在... ...
http://www.jkp-ads.com/Articles/RegisterUDF01.asp
m,
re: developing an add-in
Questions that may help...
Are you using the Application.MacroOptions method to assign the category?
Are the functions to be called from a worksheet using a formula or called by other functions/subs?
Have you seen/read "Registering a User Defined Function with Excel" by Jan Karel Pieterse at...
http://www.jkp-ads.com/Articles/RegisterUDF01.asp
$
Jim Cone
美国俄勒冈州波特兰市
https: //goo.gl/IUQUN2 (Dropbox)
Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)
这篇关于Excel Addin打开的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!