Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Houston, Texas, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing References? (2000/SR1)

    I've developed a macro that runs beautifully on my system. I sent it to others who need to use it and told them that they need to check the following references that were checked on my system:

    Visual Basic for Applications
    OLE Automation
    Microsoft Project 9.0 Object Library
    Microsoft Office 9.0 Object Library
    Microsoft Forms 2.0 Object Library

    However, even after they check these, the macro won't run. Their systems have an additional reference "MISSING: Microsoft 10.0 Object Library" checked. We can uncheck it if no project is loaded, but when we load a project, we get the same error message "Compile error: Can't find project or library". They are running 2000/SR1 just as I am.

    What can we do so that the macro will run on their systems?

    Thanks,
    Caroline

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Missing References? (2000/SR1)

    It sounds as if you are running slightly different operating systems. I know you can refer to the reference in code but don't remember how. Let me see if I can get some help on this one.
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing References? (2000/SR1)

    The 10.0 refers to Office XP:
    Office 97 = 8.0
    Office 2000 = 9.0
    Office XP (aka 2002) = 10.0
    Office 2003 = 11.0
    So they habe probably installed at least one component of Office XP.

    But I suspect that they missed a word between "Microsoft 10.0" and "Object Library". By itself, "Microsoft 10.0 Object Library" is meaningless, I think. Can you ask them what the exact text of the missing reference is?

  4. #4
    Star Lounger
    Join Date
    Feb 2004
    Location
    Houston, Texas, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing References? (2000/SR1)

    The actual wording is "MISSING: Microsoft Project 10.0 Object Library". The Microsoft installation is 2000, network-based. However, it is possible that one of the project plans was modified on a laptop running XP. Would that account for it?

    Thanks,
    Caroline

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing References? (2000/SR1)

    Project 10.0 is Project 2002 / XP. If the project plan was modified on a machine with Project 2002 / XP, the reference would be updated automatically to Microsoft Project 10.0 Object Library; this could cause problems if the file was subsequently opened on a machine with Project 2000. (In an ideal world, the reference would update itself again, but unfortunately, that doesn't always happen...)

    The following should work (but it is a nuisance, I admit):
    Select Tools | References...
    Uncheck "MISSING: Microsoft Project 10.0 Object Library".
    Click OK.
    Select Tools | References... again.
    Check "Microsoft Project 9.0 Object Library".
    Click OK.

  6. #6
    Star Lounger
    Join Date
    Feb 2004
    Location
    Houston, Texas, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing References? (2000/SR1)

    Thanks for the good explanation - it makes sense. Only problem is that Project 2000 won't let us uncheck the "MISSING: Microsoft Project 10.0 Object Library" reference but says that it is in use. How can that be if we're running 2000?

    Thanks,
    Caroline

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing References? (2000/SR1)

    Uhmm, what happens if you open the project file with the Shift key held down? In other Office apps, that disables macros. Can you uncheck the MISSING reference then?

    If that doesn't help, I'll have to leave this thread to others, I know nothing about Project at all...

  8. #8
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Missing References? (2000/SR1)

    Caroline,

    Were you able to solve the problem?
    Regards,

    Gary
    (It's been a while!)

  9. #9
    Lounger
    Join Date
    Feb 2004
    Location
    Belgium
    Posts
    30
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Missing References? (2000/SR1)

    Hi,

    don't knw if you are sill loking for an answer and not certain this is indeed the right one.
    Sub references()
    On Error Resume Next
    'Visual Basic For Applications
    ThisWorkbook.VBProject.references.AddFromGuid "{000204EF-0000-0000-C000-000000000046}", 4, 0
    'Microsoft Excel 9.0 Object Library
    'ThisWorkbook.VBProject.references.AddFromGuid "{00020813-0000-0000-C000-000000000046}", 1, 3
    'Microsoft Excel 10.0 Object Library
    ThisWorkbook.VBProject.references.AddFromGuid "{00020813-0000-0000-C000-000000000046}", 1, 4
    'Microsoft Forms 2.0 Object Library
    ThisWorkbook.VBProject.references.AddFromGuid "{0D452EE1-E08F-101A-852E-02608C4D0BB4}", 2, 0
    'Microsoft Visual Basic for Applications Extensibility 5.3
    ThisWorkbook.VBProject.references.AddFromGuid "{0002E157-0000-0000-C000-000000000046}", 5, 3
    'Microsoft Outlook 9.0 Object Library
    ThisWorkbook.VBProject.references.AddFromGuid "{00062FFF-0000-0000-C000-000000000046}", 9, 0
    'Microsoft Outlook 10.0 Object Library
    ThisWorkbook.VBProject.references.AddFromGuid "{00062FFF-0000-0000-C000-000000000046}", 9, 1
    'Microsoft Office 10.0 Object Library
    ThisWorkbook.VBProject.references.AddFromGuid "{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}", 2, 2
    'Microsoft Word 10.0 Object Library
    ThisWorkbook.VBProject.references.AddFromGuid "{00020905-0000-0000-C000-000000000046}", 8, 2
    'Microsoft ActiveX Data Objects 2.5 Library
    ThisWorkbook.VBProject.references.AddFromGuid "{00000205-0000-0010-8000-00AA006D2EA4}", 2, 5
    'Microsoft DAO 3.6 Object Library
    ThisWorkbook.VBProject.references.AddFromGuid "{00025E01-0000-0000-C000-000000000046}", 5, 0
    'Microsoft Data Formatting Object Library 6.0 (SP4)
    ThisWorkbook.VBProject.references.AddFromGuid "{6B263850-900B-11D0-9484-00A0C91110ED}", 1, 0
    'OLE Automation
    ThisWorkbook.VBProject.references.AddFromGuid "{00020430-0000-0000-C000-000000000046}", 2, 0
    'Microsoft Access 10.0 Object Library
    ThisWorkbook.VBProject.references.AddFromGuid "{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}", 9, 0

    End Sub

    this code will do automactically what you do when manually chcking and uncheng references
    to find out which references were included in your project

    Sub AddInnsInformation()
    ' Examines VBA References
    ' Dana DeLouis

    Dim objReferences As Object
    Dim objReference As Object
    Const Str1 As String = "Copy this-> .AddFromGuid """
    Const Str2 As String = "Copy this-> .Item(""?"")"

    Set objReferences = ThisWorkbook.VBProject.references

    Debug.Print String(40, "= ")
    For Each objReference In objReferences
    With objReference
    Debug.Print .Description
    Debug.Print vbTab & "Name:= " & .name
    Debug.Print vbTab & "Guid:= " & .Guid
    Debug.Print vbTab & "Major:= " & .Major
    Debug.Print vbTab & "Minor:= " & .Minor
    Debug.Print vbTab & "BuiltIn:= " & .BuiltIn
    Debug.Print vbTab & "IsBroken:= " & .IsBroken
    Debug.Print vbTab & "Type:= " & .Type
    Debug.Print vbTab & "FullPath:= " & .FullPath
    Debug.Print
    Debug.Print vbTab & Str1 & .Guid & """," & .Major & "," & .Minor
    Debug.Print vbTab & Replace(Str2, "?", .name)
    Debug.Print
    End With
    Next objReference
    Debug.Print String(40, "= ")
    Set objReferences = Nothing
    End Sub

    have fun,
    jan

Posting Permissions

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