Results 1 to 2 of 2

Thread: GUID for Excel 2007

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    VBAX Regular
    Joined
    Feb 2008
    Posts
    32
    Location
    Can someone with Excel 2007 provide me with the GUID for Microsoft Works Calendar 5.0 Type Library? (I have Excel 2002 SP3, and I can't find this information online. This will help with part one of my question.)

    The method I used to determine the GUID is the following:
    Open VBAProject (Alt-11) and in Tools>References check the Microsoft Works Calendar 5.0 Type Library.

    Then run the following code supplied by a KB at this site. (I put into a module and then ran it from a blank worksheet)

     
    Option Explicit
     
    Sub ListReferencePaths()
         ' Macro purpose:  To determine full path and Globally Unique Identifier (GUID)
         ' to each referenced library.  Select the reference in the Tools\References
         ' window, then run this code to get the information on the reference's library 
        On Error Resume Next
        Dim i As Long
        With ThisWorkbook.Sheets(1)
            .Cells.Clear
            .Range("A1") = "Reference name"
            .Range("B1") = "Full path to reference"
            .Range("C1") = "Reference GUID"
        End With
        For i = 1 To ThisWorkbook.VBProject.References.Count
            With ThisWorkbook.VBProject.References(i)
                ThisWorkbook.Sheets(1).Range("A65536").End(xlUp).Offset(1, 0) = .Name
                ThisWorkbook.Sheets(1).Range("A65536").End(xlUp).Offset(0, 1) = .FullPath
                ThisWorkbook.Sheets(1).Range("A65536").End(xlUp).Offset(0, 2) = .GUID
            End With
        Next i
        On Error GoTo 0
    End Sub
    Last edited by Aussiebear; 07-11-2025 at 04:48 PM.

Posting Permissions

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