This is one I don't understand. I'm porting a heap of code out of an excel
class module into a VB6 activex dll for security reasons, and to provide a
multi-app interface that I can use in Word later.

It works fine, much to my surprise since I've always been horribly confused
about com add-ins and such, but every time I amend the code in the dll and
recompile it, when I reload the code in excel that has a reference to the
dll, I get a Misssing error even though the recompiled dll is in exactly the
same place as before.

The solution is fairly simple but very annoying: goto Tools, Reference,
uncheck the missing reference, click OK. Then do it again, Tools, Reference,
the reference is there without a missing flag this time, and I can reselect
it with no problems.

Any suggestions as to what is going on and how I can stop this? Would it be
a changing prog ID or something that is being done during the compile in VB?

Thanks,

Robin Hammond
www.enhanceddatasystems.com