Re: Can't see References from toolbar

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

On 15 May 2007 09:12:40 -0700, HockeyFan <les.stockton@xxxxxxxxx>
wrote:

I've got a user (at a remote location) having trouble with an
application that I wrote in VBA within Excel.
It runs on some machines, but not all. I've determined that it's
missing some dll because of the error popup that says it's missing a
project or library.

So I asked the user to view references. They tell me that they go to
Tools within VBE, but that the References option is greyed out. What
would cause this?

It could be that your user is executing VBA code at the time that he
views. This disables the References... option.

Hope that helps, Chris

Bye for now,

Chris Jakeman
Peterborough, UK
.

Relevant Pages

  • Re: Why "Name IsNull is not declared"?
    ... but I am not using VBA I am using VB studio 2005. ... What am I missing? ... This appears to be the very common References bug. ... Uncheck it, recheck it, close and open Access. ...
    (microsoft.public.access.gettingstarted)
  • Re: To declare the library when using a function?
    ... Cindy is correct that this due to a missing reference, but not the VBA library itself, which should be available. ... When you try to use a function that is not fully qualified, VBA wants to look at all references to resolve the qualification and if there is any missing one at all, it gets stuck. ...
    (microsoft.public.word.vba.general)
  • Re: Why "Name IsNull is not declared"?
    ... but I am not using VBA I am using VB studio 2005. ... error inside ot VB editor. ... What am I missing? ... This appears to be the very common References bug. ...
    (microsoft.public.access.gettingstarted)
  • Re: To declare the library when using a function?
    ... The problem is that on some other PCs this problem appears, and I cannot ask the user to open the VBA environment for solving the problem. ... When you try to use a function that is not fully qualified, VBA wants to look at all references to resolve the qualification and if there is any missing one at all, it gets stuck. ...
    (microsoft.public.word.vba.general)
  • Re: VBA errors in 2007 (works fine in 2003)
    ... It's just breaking on the Mac version of Excel. ... Pak allowing you to call functions in the ATP from within VBA. ... menu in VBA, choose References, and select "atpvbaen.xls". ... If there is the possibility of a name collision (two or more libraries ...
    (microsoft.public.excel.misc)