"MV" wrote in message
...
Hi,

I built a VB6 COM dll with only business logic (no UI) designed to work
with
Excel (this will be thwe UI).

I'm trying to find the best way to deploy this into production in order to
avoid dll-hell in future upgrades.

I understand there's something like and Excel COM add-in but haven't been
able to find documentation on how to do this.


You can actually call your exposed com interfaces directly from
VBA providing the instancing on the class is set to GlobalMultiUse

Just set a reference from the VBA to your dll and voila there they are

Alternately you can use a com add-in

http://support.microsoft.com/?kbid=238228

Keith