Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Eugene, Oregon, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    String Commands Stopped Working? (VBA-OF2000 SR-1)

    One user's machine just stopped recognizing the "RIGHT", "LEFT" or "MID" commands in the VBA coding on her machine. Any thoughts on what could be causing this problem?

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: String Commands Stopped Working? (VBA-OF2000 SR-1)

    It sounds like there is a missing reference.

    Open the VBE (ALT+F11), Select Tools|References.. from the menu and look for any that start with Missing:

    Uncheck that one and then locate the correct reference and check that one.

    For Example if there is a reference to Microsoft Rich Text Control 6.0 that is marked as missing, uncheck it and then look in the list for Microsoft Rich Text Control 6.0 (SP4) and check that one.

    If that isn't it, which app is this happening in? is it a specific document/workbook/template... or all of them?
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Eugene, Oregon, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: String Commands Stopped Working? (VBA-OF2000 SR-1)

    thanks bryan! somehow, this user's machine lost its Microsoft Scripting Runtime (scrrun.dll)--it had had it yesterday and for many months before but today, it just didn't exist anymore. anyhow, i copied a new one onto her system, re-registered it and everything's running smoothly now. thanks again!

Posting Permissions

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