Consulting

Results 1 to 5 of 5

Thread: Sleeper: VBA Error message

  1. #1
    VBAX Regular
    Joined
    Sep 2005
    Location
    Rome
    Posts
    20
    Location

    Sleeper: VBA Error message

    Hi again,
    I'm developing an application (a kind of dictionary for my students) and when I try it on their computers, it gives me weird errors:
    Things like LCase(myString) where LCase gives the problem, or Mid().
    Is it because certain Libraries are not loaded on their pcs?
    Is there a way around this?

    Does anyone have any ideas?

    GSD

  2. #2
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    Yes, it sounds like a references issue.

    In the VBE, look under Tools > References and see if anything is flagged as MISSING.
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

  3. #3
    VBAX Regular
    Joined
    Sep 2005
    Location
    Rome
    Posts
    20
    Location
    Thanks,
    That confirms what I thought. The problem remains, however.
    Is there anyway that the "missing" included using VBA?
    Thanks

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Quote Originally Posted by gsdonald
    Thanks,
    That confirms what I thought. The problem remains, however.
    Is there anyway that the "missing" included using VBA?
    Thanks
    Are you sure? Did you uncheck the MISSING items in the list?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    Quote Originally Posted by gsdonald
    Thanks,
    That confirms what I thought. The problem remains, however.
    Is there anyway that the "missing" included using VBA?
    Thanks
    It isn't easy and it does depend on what the missing reference is and why it's missing. It isn't something that can be done for a general case.

    Can you not use late binding so that the reference isn't needed?

    What is missing anyway?
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •