如何使用activeX dll创建excel插件(excel 2003或以前版本)包?
我是 Excel 插件编程新手,我有一个现有的 Excel 插件项目需要修改。
该插件有两部分,一部分是用 VB 编程并编译成 ActiveX DLL 文件,另一部分是在 Excel 中作为加载项。
我已经修改了DLL的源代码并重新编译了一个新的DLL,但我不知道将这两部分重新打包成一个Excel加载项包并提供给我的同事的正确方法是什么。
我试图从 Excel 中删除对旧 DLL 的引用,但似乎我无法做到这一点,它总是在那里,我无法真正删除它。
此插件适用于 Excel 2003 或以前的版本,不适用于 Excel 2007。
非常感谢您的帮助!
I am new to excel add-in prgramming and I am having a existing excel add-in project need to modify.
The plug-in has 2 parts, one is programmed in VB and compiled into a ActiveX DLL file, the other part is inside the excel as an add-in.
I already modified the source code of the DLL and recompiled a new DLL, but I don't know what is the correct way to re-package the 2 parts into one excel add-in package and give to my colleagues.
I tried to remove the reference to old DLL from excel, but it seems I could not do that, it will always be there and I can't really remove it.
This add-in is for excel 2003 or previous version, not for excel 2007.
thanks a lot for your help!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
欢迎来到 DLL 地狱!
您必须删除对旧 dll 的引用。
看一下: regsvr32
regsvr32 / u [旧 dll 的路径]/[文件名]
regsvr32 [新 dll 的路径]/[文件名]
例如:
regsvr32 /uc:\windows\system32\file.dll
您可以添加 /q 来隐藏所有消息
您如何为同事重新打包它?有多种方法。创建一个bat 文件并通过电子邮件发送它,将其作为登录脚本的一部分。或者到每个工作站手动进行
Welcome to DLL Hell!
You'll have to remove the reference to the old dll.
Have a look at: regsvr32
regsvr32 /u [path of old dll]/[filename]
regsvr32 [path of new dll]/[filename]
Eg:
regsvr32 /u c:\windows\system32\file.dll
You can add /q to hide all messages
How do you repackage it for your colleagues? There are multiple ways. Create a bat file and email it, put it as part of the logon script. Or go to each workstation and manually do it