Compile Error - Can't find project or libraries
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Compile Error - Can't find project or libraries

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have recently completed a project and given it out for bug testing. One user has been presented with the compile error when attempting to run any of the macros in the sheet. All machines are running Excel 97-SR2, macros enabled. All users are running the same template file. It onlt affects 1 out of 6 testers - what could be the cause of this problem?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    On the machine giving the errors...
    Open VBA development environment,
    Click on tools, references, and see which reference is missing.
    Make sure the workbook in question is up and running.
    May be the file was deleted, replaced, or is in the wrong place.

    If it is an error on a line with a left, right, mid, or other string function.

    Precede the string function with Strings.

    For ex.

    MyString = Left(MyVar,3)

    Change to:

    MyString = Strings.Left(MyVar,3)

    Have had a lot of problems with this class.

    Tom

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    On the machine giving the errors...
    Open VBA development environment,
    Click on tools, references, and see which reference is missing.
    Make sure the workbook in question is up and running.
    May be the file was deleted, replaced, or is in the wrong place.
    The missing reference is:

    VideoSoft vsflex2 Controls

    winntsystem32vsflexlib.TWD

    I cannot uncheck this box as it says it is in use.

    Ref Edit Control is checked but is not on any of the other machines.

    MS VBA for Extensibility is unchecked on the rogue machine and checked on all others. If you check it, then close the VBA editor and reopen the references, VBA for Ext is again unchecked.

    Any ideas on what to do?


    [ This Message was edited by: Mr Nick on 2002-04-10 03:20 ]

    [ This Message was edited by: Mr Nick on 2002-04-10 03:21 ]

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here's an idea. I don't know if it is your only way out of this.

    Clear all of the references that you can, some you cannot, delete the sys file temporarily if need be, and then register the libraries via code.

    An example for Outlook's Library

    ThisWorkbook.VBProject.References.AddFromGuid _
    "{00062FFF-0000-0000-C000-000000000046}", 9, 0

    You will need to find out where the reference is in the registry.

    Regedit, search for the name of the dll,tlb,exe,ocx,twd,ect...

    Another thought, an NT machine...
    Which service pack?
    Permissions?
    Who knows...
    Out of my ballpark...

    Tom

    [ This Message was edited by: TsTom on 2002-04-10 03:35 ]

    [ This Message was edited by: TsTom on 2002-04-10 03:36 ]

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    All sorted. Found that the VideoSoft stuff was not on the rogue machine. It's not needed by the sheet so took the references out of the master template via my machine and all is honky dory!

    Cheers Tom.

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    We all love a happy ending!
    Cheers returned!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com