在Excel（VBA）中取消注册XLL [英] Unregister a XLL in Excel (VBA)

问题描述

我刚刚发现使用Visual C ++ 2010中的XLW编程XLL的Excel的世界，迄今使用XLW包提供的模板一切顺利，我有几个问题：

1. 我发现我可以通过双击来注册XLL。还有什么其他方法，特别是从VBA或Excel菜单？


2. 如何通过Excel GUI和VBA取消注册XLL？我假设每次在Visual Studio下重建Xll时，都必须完成此操作。


3. Excel 2010 64位需要XLL编译并链接64位吗？

谢谢，
Steve

解决方案

通常使用下面，因为我必须在excel会话期间多次借用/卸载xla。让我知道如果它适用于你：

  AddIns.Add文件名：=C：\test\1.XLL 
 AddIns（Pricer Add-In）Installed = False 
 
 AddIns.Add文件名：=C：\test\Arbitrage.XLL
 AddIns Pricer Add-In）。Installed = True 
  

你必须确保文件路径和名称插件匹配。要检查插件的名称，请转到工具 - >Addin。

您还可以使用记录宏功能，并从工具 - > Addin开始录制和禁用/启用加载项/ xll。祝你好运

I am just discovering the world of programming XLLs for Excel using XLW under Visual C++ 2010 and everything has been smooth so far using the template provided with the XLW package, I have a few questions:

1. I found out that I can register an XLL by double-clicking it. What other ways are there, especially from VBA or the Excel menu?
2. How can I unregister an XLL, both via the Excel GUI and VBA? I assume this has to be done each time I rebuild the Xll under Visual Studio.
3. Does Excel 2010 64-bit require XLLs compiled and linked for 64-bit?

Thanks, Steve

解决方案

I usually use below as I have to loan/unload xla multiple times during excel session. Let me know if it works for you:

AddIns.Add Filename:= "C:\test\1.XLL"
AddIns("Pricer Add-In").Installed = False

AddIns.Add Filename:= "C:\test\Arbitrage.XLL"
AddIns("Pricer Add-In").Installed = True

you have to make sure that filepath and name of the addin match. To check the name of the addin, go to Tools -> Addin.

you can also use "Record Macro" feature and start recording and disable/enable the addin/xll from Tools -> Addin. Good luck

这篇关于在Excel（VBA）中取消注册XLL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！