Re: Cannot find VBA definition in XP Only

From: Tim Ferguson (FergusonTG_at_softhome.net)
Date: 03/24/05 

Date: Thu, 24 Mar 2005 09:39:54 -0800

"=?Utf-8?B?Um9iZXJ0MTEwNQ==?=" <Robert1105@discussions.microsoft.com>
wrote in news:D4CD0A64-D1E3-40E9-A1DA-D37B01FB17AC@microsoft.com:

>
> We are experiencing problems with the VBA Reference even though the
> Visual Basic for Applications is a selected referenced. One example
> is with CHR$(13). When we right click to find the definition, it
> cannot find it? The error we receive is:

You are quite right that this is a References problem. Look in the
References list in the VB Editor and look for *any* missing reference.
Either uncheck it or remove it altogether. If it's a library you need
then you'll have to find it manually or check the installation etc; if
it's one you don't need then don't worry any further.

The point is that VBA is really sensitive to a missing reference anywhere
in the environment, and the commonest symptom is for plain VB functions
(such as Date() or Chr$() etc) to fail, regardless of which library is
broken.

Hope that helps

Tim F

Relevant Pages

  • Re: Cannot find VBA definition in XP Only
    ... >We are experiencing problems with the VBA Reference even though the Visual ... >is that previous version has a reference of Microsoft Access 9.0 Object ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access97 And Access XP References
    ... You will need the VBA reference MS Active ... > reference in the list of selected references in Access 97 and/or Access ... > as a missing reference when applications get migrated to Access XP. ...
    (microsoft.public.access.formscoding)
  • 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: Cannot find Project or Library error
    ... Y've got a broken reference in yr VBA project, ... a library/activeX comp is reported missing. ... Locate the MSCOMCTL.ocx file on yr system, and try to point yr VBA reference ...
    (microsoft.public.word.vba.userforms)
  • 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)