How to create excel add-in package (excel 2003 or previous version) with activeX dll?

Question

I am new to add-in add-in programming and I need to modify an existing excel add-in project.

The plugin consists of 2 parts, one of them is programmed in VB and the ActiveX file is compiled into a DLL, and the other part is inside excel as an add-in.

I have already changed the source code of the DLL and recompiled the new DLL, but I do not know how to properly repack 2 parts into one excel add-on package and provide it to my colleagues.

I tried to remove the link to the old DLL from excel, but it seems that I could not do this, it will always be there, and I can not delete it.

This add-in is for Excel 2003 or a previous version, not Excel 2007.

Many thanks for your help!

Answer 1

Welcome to the DLL Hell!

You will need to remove the link to the old dll.

Take a look: regsvr32

• Close excel
• Click Start / Run / cmd
• A type regsvr32 /u [path of old dll]/[filename]
• Then regsvr32 [path of new dll]/[filename]

For instance:  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 several ways. Create a bat file and send it by email, put it as part of the login script. Or go to each workstation and manually do it