Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Error (Excel 2000)

    Hi all,

    I am getting an the Error "Can't find Library" I'm a bit confused as to why, I don't get the error on my own machine, but when I copied a template to another PC it couldn't find the Library. I read the help file, but that didn't help. Any ideas?

    Thanks Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Error (Excel 2000)

    Do the following on thePC where the error occurs:
    - Open the template.
    - Activate the Visual Basic Editor (Alt+F11).
    - Select Tools | References...
    - Most probably, one of the references starts with MISSING.
    - Note which reference it is, in case you need it later.
    - Clear the check box for the MISSING reference.
    - Click OK.
    - Test if the template works now.
    - If not, you may have to find the missing library - it may be installed in another folder than on your own PC, or perhaps it isn't installed at all.

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Error (Excel 2000)

    Hi Hans,

    I did what you said, but what it was referring to was "format" and also Msgbox Ucase("message"), "UCASE", What Library would I need to pick for those two?

    Or should I have Microsoft office installed again?- it makes me curious, cause I have a calendar control on a form that didn't load on another computer, got a message "Could not load object on this computer" but loaded on two out of 4.....

    Thanks,

    Darryl.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Error (Excel 2000)

    The Microsoft Calendar control is not installed with the standard version of Office, it comes with Microsoft Access, i.e. with Office Professional and Office Developer Edition. So a form with a calendar control will not work on a PC with a standard version of Office.

  5. #5
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Error (Excel 2000)

    Thanks,
    Hans.

Posting Permissions

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