Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    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?


  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Silicon Valley, USA
    Thanked 94 Times in 90 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>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts