Re: Excel VBA - Dll reference problem

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

So, your problem is with a checked, but missing reference.
I think there should be a way to handle that. Will have a look.

RBS

"bad_boyu" <silaghi.ovidiu@xxxxxxxxx> wrote in message news:1148592528.803351.71730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Is not working because when a reference is checked and is "Missing"
than: References.Remove R does not work, you get an error! From some
unknown reason, you can remove this reference only from menu.. I did
not find any function for doing that from code.. Is there a function
to test if a reference is checked but is "Missing"? I could do that
only by catching the error and test the Err.Number.


.

Relevant Pages

  • Re: Compile Error: Cant Find Project or Library
    ... A missing reference can cause elements defined in other libraries to raise these errors. ... If, however, you do need that library and you know where it came from, close Excel and re-install the program that created the reference in question. ...
    (microsoft.public.excel.programming)
  • Re: Excel 2003 VBProject Missing reference
    ... user it's always best avoid the issue altogether, remove the reference your ... I am not up with Late / Early binding, ... Set PPTApp = CreateObject ... What code will programatically remove the missing reference? ...
    (microsoft.public.excel.programming)
  • Re: missing reference and Access runtime
    ... > have an Access 2002 application that I packaged using InstallShield and ... > reference to MSWORD.olb version 8.2. ... > missing reference is causing the problem, but since I'm having to use the ... If you are distributing apps to multiple users ...
    (microsoft.public.access.formscoding)
  • Re: import multiple text files into Access 2003(different file names)
    ... Jon V ... Problems like this are often caused by a missing reference in the VBA ... John Nurick ...
    (microsoft.public.access.externaldata)
  • Re: I just installed Office 2003...
    ... it's possible that removing the missing reference in 1 might ... Doug Steele, Microsoft Access MVP ... I've just installed Access 2003 at home - the install was successful and ...
    (microsoft.public.access.setupconfig)