Re: Excel References

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rob Bovey (Rob_Bovey_at_msn.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 06:27:01 -0800

Hi Joe,

     If you have a MISSING reference on a machine where you're sure the
component is properly registered, try unchecking the missing reference and
closing the References dialog, then reopen the References dialog and recheck
the reference. 

-- 
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
"Joe" <anonymous@discussions.microsoft.com> wrote in message
news:A7EC9FFA-2E18-470D-8FE1-4A140364A6A5@microsoft.com...
> Please see below.
>
>      ----- Rob Bovey wrote: -----
>
>      Hi Joe,
>
>      <<If I have the References dialog open, I can't get to the Browser
(as
>      indicated in Help); I tried that and it didn't work.  I had to close
the
>      References dialog.>>
>
>        **Let's make sure we're talking about the same thing. In the Excel
Visual
>      Basic Editor (VBE) you choose the Tools/References menu to open the
>      References dialog. On the References dialog there is a Browse button
located
>      directly below the Cancel button. If you click this button you will
get a
>      File/Open-style Add References dialog. Use this dialog to navigate to
and
>      select your DLL. Click OK and the VBE will register the DLL and add
it to
>      the Available References listbox.**
>
>             This helps but still does not solve the problem.  I do
appreciate your explanation,
>             though, because I couldn't understand what MS was talking
about when they referred
>             to the Browser.
>
>      <<I have also noticed that when the XL workbook is opened on other
machines,
>      an error appears indicating that it can't find the referenced library
>      (MISSING is present) and the path to the DLL is given as the path
that it
>      would have on my machine>>
>
>        **The MISSING flag in the References dialog means that the flagged
>      component has not been properly registered on that machine.**
>
>             If I see a component listed in the Registry giving its patha
dn
>             threading model, can I assume that it has been registered?
>             This is what I have seen when the MISSING flag is displayed
>             in the References dialog.
>
>      <<How do I know if the DLL is a valid ActiveX DLL?>>
>
>        **The easiest way is to attempt to register the DLL with the
Windows
>      command-line registration tool Regsvr32.exe. Open a command prompt
and enter
>      the following on the command line:
>
>      C:\>Regsvr32 C:\YourPath\YourDLL.DLL
>
>      where the actual path and file name identify the DLL you are trying
to
>      register. If the DLL is a valid ActiveX DLL you will get a success
message
>      and the DLL will be registered on the machine (registering multiple
times
>      won't hurt anything). If the DLL is not an ActiveX DLL you will get a
>      failure message indicating that the DLL could not be registered, in
which
>      case it is not the type of DLL that can be referenced through the
>      Tools/References dialog.**
>
>            I have done this and have still seen the MISSING flag.  This
>            is what has been so frustrating.
>
>      -- 
>      Rob Bovey, MCSE, MCSD, Excel MVP
>      Application Professionals
>      http://www.appspro.com/
>
>      * Please post all replies to this newsgroup *
>      * I delete all unsolicited e-mail responses *
>
>
>      "Joe" <anonymous@discussions.microsoft.com> wrote in message
>      news:9AE3715D-0EBF-4741-A0C0-F2DCEC2CB310@microsoft.com...
>      > Rob,
>      >> If the DLL is listed in the References list and doesn't include
the word
>      MISSING in the name, the Browser lists it in the dropdown of
available
>      libraries.  If MISSING is included, then the browser doesn't include
it in
>      the list of available libraries.
>      >> If I have the References dialog open, I can't get to the Browser
(as
>      indicated in Help); I tried that and it didn't work.  I had to close
the
>      References dialog.
>      >> I have also noticed that when the XL workbook is opened on other
machines,
>      an error appears indicating that it can't find the referenced library
>      (MISSING is present) and the path to the DLL is given as the path
that it
>      would have on my machine.  For example, I would see
>      D:\WINNT\System32\CTXS.dll listed as the path to the DLL.  This is
fine for
>      my machine, but for others who local drive is C:, this raises the
error that
>      Excel can't find the library.
>      >> How do I know if the DLL is a valid ActiveX DLL?  BTW, I'm using
Inno
>      Setup 4 and ISTOOL for the deployment of the XL workbook and the DLL.
>      >> THanks,
>      >> Joe
>      >>>>>>      ----- Rob Bovey wrote: -----
>      >>      Hi Joe,
>      >>          The references list is just a list of COM components from
the
>      registry.
>      >      A couple ideas: Are you sure that your DLL is a valid ActiveX
DLL?
>      What
>      >      happens if you use the Browse button to point Excel at your
DLL?
>      >>      -- 
>      >      Rob Bovey, MCSE, MCSD, Excel MVP
>      >      Application Professionals
>      >      http://www.appspro.com/
>      >>      * Please post all replies to this newsgroup *
>      >      * I delete all unsolicited e-mail responses *
>      >>>      "Joe" <anonymous@discussions.microsoft.com> wrote in message
>      >      news:B53CD110-146A-4202-9EA9-CD537084D4E4@microsoft.com...
>      >> Does anyone know how Excel loads the References dialog in the VBE?
>      >>> I have registered a DLL and XL still claims that it can't find
it.
>      Is
>      >      there a registry setting that I have to set for XL to find a
DLL?
>      >>> Any help would be greatly appreciated.
>      >>> Thanks,
>      >>> Joe
>      >>>

Relevant Pages

  • Re: Excel References
    ... Do you know of any routines that could check to see if the DLL is referenced and, if it is not, set a reference to it? ... closing the References dialog, then reopen the References dialog and recheck ... Rob Bovey, MCSE, MCSD, Excel MVP ... Click OK and the VBE will register the DLL and add ...
    (microsoft.public.excel.programming)
  • Re: Excel References
    ... registers the DLL properly on the user's machine then there shouldn't be any ... I re-establish the References, XL runs fine. ... "Joe" wrote in message ... Click OK and the VBE will register the DLL ...
    (microsoft.public.excel.programming)
  • Re: HowTo: Unregister a DLL/Control when the File no longer Exists
    ... Tony Proctor wrote: ... recorded in the registry. ... However, matching them up without the original DLL ... The main project references one of the DLLs, ...
    (microsoft.public.vb.general.discussion)
  • Re: Excel References
    ... <<If I have the References dialog open, I can't get to the Browser (as ... Click OK and the VBE will register the DLL and add it to ... the Browser lists it in the dropdown of available ...
    (microsoft.public.excel.programming)
  • Re: Trim Function - Error Library Not Found
    ... I checked, nothing was missing. ... older DLL, but I can't figure out what DLL Trim resides in. ... >> We have a excel spread sheet that has a bunch of VBA in it. ... >> verified that they has the same references as me. ...
    (microsoft.public.excel.programming)