如何用activeX dll创建excel加载项（excel 2003或以前的版本）包？ [英] How to create excel add-in (excel 2003 or previous version) package with activeX dll?

问题描述

我是崭新的excel加载项编程，而我现在有一个现有的excel加载项目需要修改。

插件有2个部分，一个在VB中编程并编译成一个ActiveX DLL文件，另一部分是作为加载项的excel内部。

我已经修改了DLL的源代码并重新编译了一个新的DLL，但我不知道什么是正确的方式重新打包2部分到一个excel加载项包，并给我的同事。

我试图从excel中删除对旧的DLL的引用，但是似乎我无法做到这一点，它总是存在，我无法真正删除它。

此加载项适用于excel 2003或以前的版本，而不适用于excel 2007。

非常感谢您的帮助！

解决方案

欢迎来到DLL Hell！

你必须删除对旧的dll的引用。看看： regsvr32

1. 关闭Excel


2. 单击开始/运行/ cmd


3. 键入 regsvr32 / u [old dll的路径] / [filename]


4. 然后 regsvr32 [new dll的路径] / [filename]

例如：
regsvr32 /uc:\windows\system32\file.dll

你可以添加/ q来隐藏所有消息

如何重新打包给同事？有多种方式创建一个蝙蝠文件并发送电子邮件，将其作为登录脚本的一部分。或者去每个工作站手动执行

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!

解决方案

Welcome to DLL Hell!

You'll have to remove the reference to the old dll.

Have a look at: regsvr32

1. Close Excel
2. Click Start / Run / cmd
3. Type regsvr32 /u [path of old dll]/[filename]
4. Then 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

这篇关于如何用activeX dll创建excel加载项（excel 2003或以前的版本）包？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！