VBA --Refreance

[123]

Hello!
How to open reference dialog box using command in a form…
Notes this will run time only so I will not using alt + F11 to open VBA
application and tools --- reference…

 

[Douglas J. Steele]

I don't believe you can open the References Dialog box in the run-time
version.

 

[123]

thank you
I don't mean run time Microsoft Office XP Developer I mean by runtime the
form is not in design view or the form in form view this what I mean

 

[Douglas J. Steele]

You must be in VB Editor to invoke the Dialog, and there's no way that I'm
aware of to do it from code.

On the other hand, you could write your own code to list the references.

Sub ReferenceProperties()
Dim ref As Reference

' Enumerate through References collection.
For Each ref In References
' Check IsBroken property.
If ref.IsBroken = False Then
Debug.Print "Name: ", ref.Name
Debug.Print "FullPath: ", ref.FullPath
Debug.Print "Version: ", ref.Major & "." & ref.Minor
Else
Debug.Print "GUIDs of broken references:"
Debug.Print ref.GUID
EndIf

Next ref
End Sub