Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Left(something,2) Not working (2000)

    Hi all,

    I am using some code which includes this lin. intStart1 = CInt(Left(strCRN, 2)) the code opens letters for me and uses this line to read the first 2 numbers of the filename in order to find the directory. Heres the problem...

    When I installed this macro on several other machines it seems to work fine no matter who is logged in, except for one.

    On this one particular machine If I am logged in it works fine but if the person whos machine it is logs in it does not work it falls over on the line word 'Left' I am sorry I cant remeber the exact message and can't get in her office till Monday but I think it was object not found.

    Any ideas

    Many thanks
    Regards
    Gerbil (AKA Kevin)

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Left(something,2) Not working (2000)

    Any unusual add-ins in that person's profile that might have a function/method named Left?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts

    Re: Left(something,2) Not working (2000)

    I've seen a similar situation with Left or InStr when a Reference is missing. Scripting Runtime is sometimes the culprit.

  4. #4
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Left(something,2) Not working (2000)

    Many Thanks, I will have a look at this tomorrow
    Regards
    Gerbil (AKA Kevin)

  5. #5
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Left(something,2) Not working (2000)

    I am not sure I wont be able to get in her office till tomorrow but will have a look

    Many thanks
    Regards
    Gerbil (AKA Kevin)

Posting Permissions

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