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