To get a list of the references and their GUID, use the following procedure...

'/==========================================/
Public Sub ReferenceList()
Dim objRef As Object
Dim strAnswer As String

For Each objRef In ActiveWorkbook.VBProject.References
strAnswer = strAnswer & "Name: " & objRef.Name & vbCr & _
"Description: " & objRef.Description & vbCr & _
"Location: " & objRef.fullpath & vbCr & _
"GUID: " & objRef.GUID & vbCr & vbCr
Next objRef

MsgBox strAnswer

End Sub
'/==========================================/

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"tysop" wrote:

I'm trying to create an input form that contains a Date and time picker
(DTPicker) to be distributed to different versions of Excel. I am using
excel 2000, however when I open it in Excel XP I get the following error
message:
Compile Error
Can't find project or library

And in ToolsReferences I get Missing: Microsoft Windows Common
Controls-2.6.0(SP4)

Is there an easy alternative instead of the DTPicker or some code to fix this?
I don't have control over other users having any particular add-ins/updates
applied unfortunately, or even what version of Excel or what install options
were chosen.

Any help would be much appreciated.