Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compile Error (VBA6 - Office 2000 SR1a)

    Does anyone know why in Office 2000 I get the following compile error? It only happens on one or two PCs and when I compare the Office build on a PC where it works against a PC where it does'nt work the libraries are the same.

    Many thanks

    Regards

    John
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Compile Error (VBA6 - Office 2000 SR1a)

    You've probably got a broken reference. Open the VB Editor in the application (Alt+F11) and click on the Tools menu, then select References. You'll see a list of the referenced object libraries, etc. Look for one that says MISSING. If you find one, then uncheck it and compile your code. If the library is necessary, you'll get a compile error and you'll have to locate the library on that machine. If it isn't necessary, you can ignore it. Inidividual dlls can get overwritten when you install other programs, and that can cause this kind of problem, especially since different versions of the library may have the same file name.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compile Error (VBA6 - Office 2000 SR1a)

    I discovered an interesting problem regarding referenced libraries that might pertain to your situation:

    If you need a reference to the VBA Extensibility library on a PC with both Office 97 and Office 2000 or 2002, the Word reference list does not display both versions. The library list only displays the VBA6 version 5.3. I had all sorts of strange problems until I figured out that it was not my code, but the wrong Extensibility library.

    In order to get the VBA5 version to show in the list, first select the VBA6 version. Click Ok, then reopen the Reference list. You will now be able to check the VBA5 version (and uncheck to VBA6 version while you're at it).

    More lore from the bowels of VBA...
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Posting Permissions

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