Re: Excel References

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Joe (anonymous_at_discussions.microsoft.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 11:51:11 -0800

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
     
     
     

Quantcast