问题描述
我有一个XLL加载项，我试图在未安装VBA的Excel 2007 XP下运行它.我的插件已正确注册(HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 12.0 \ Excel \ Options中的/R"C:\ Program Files(x86)\ MyAddin \ myAddin.xll"打开键).调试时，我看到调用了DLLMain，但是没有调用xlAutoOpen(没有其他xlSomethings函数):因此，未注册我的UDF(这是在xlAutoOpen中完成的).我想念什么吗?我绝对需要安装VBA吗?如果是，还有另一种避免安装的方法吗?
I've got a XLL Addin and I'm trying to run it under Excel 2007 XP without VBA installed.My addin is well registered (OPEN key as /R "C:\Program Files (x86)\MyAddin\myAddin.xll" in HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options). When debuging, I see that DLLMain is called... but not xlAutoOpen (neither others xlSomethings functions): my UDFs are thus not registered (it was done in xlAutoOpen).Do I miss something ? Do I absolutly need VBA installed ? If yes, is there another way to avoid installing it ?
推荐答案
我遇到了同样的问题.当我安装Office时，我故意没有安装任何Excel加载项-看起来这实际上削弱了以后所有加载项的加载.
I had the same issue. When I installed Office I deliberately did not install any Excel Add-Ins -- it looks like this actually cripples the loading of any future Add-ins.
再次运行Office安装程序并选择安装内置"加载项之后，我终于找到了xlAutoOpen断点.
After running the Office installer again and choosing to install the 'built-in' Add-Ins, I finally hit my xlAutoOpen breakpoint.
这篇关于XLL加载不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！