Results 1 to 2 of 2
2006-02-13, 22:19 #1
- Join Date
- Nov 2001
- Melbourne, Victoria, Australia
- Thanked 0 Times in 0 Posts
Registering ActiveX (Office 2000 VBA)
I'm curious about the process of replacing an ActiveX DLL referenced in an XL workbook. Assuming that there is an existing resolved reference on the client machine, what happens if the DLL is replaced with a new version of the same name? Is it necessary to unregister then delete the old one first, before installing and registering the new one? Or can the old version be "quietly" replaced, with no harm done?
2006-02-22, 01:21 #2
- Join Date
- Feb 2001
- Silicon Valley, USA
- Thanked 93 Times in 89 Posts
Re: Registering ActiveX (Office 2000 VBA)
I think it depends on the nature of the reference.
CreateObject("ObjectName") will use whatever is defined by that name in the registry.
A DLL hardcoded in the References dialog typically has a path, so you might need to overwrite the original file with your new one. If you change the interface to the DLL, any precompiled VBA code might crash, but assuming that VBA always recompiles at run time, the new reference hopefully will be resolved successfully. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>