Results 1 to 2 of 2

Thread: Chr a missing object?

  1. Dec 7th, 2005, 07:46 AM #1
    durex
    durex is offline

    Thread Starter
    New Member
    Join Date
    Jun 2005
    Posts
    15

    Chr a missing object?

    Ive got some code in an xla file which Im trying to distribute for other users to use. It works fine on mine, but Im getting the following error on the other PC's:

    Code:
    Compile Error:
Cant find object or library
    and its hightlighting the string function Chr from Chr(34) (for double quotes). Heres a screen of exactly what Im getting...


    I thought this was included in all default VBA setups. Any ideas??

    Thanks!
    Reply With Quote Reply With Quote
  2. Dec 7th, 2005, 09:45 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Chr a missing object?

    It should be. Sometimes VBA messes up though.

    On the none working computer, open excel and the file. Tools>Macros>VB editor

    Under the References tab look for "Missing". Its probably that which is causing the problem.


    Also, is it different version of Excel? This also may cause problems (if you are going from say 2003 to 97).

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width