Are the Tools/References for DLL Registration included in a collection 1

[SBendBuckeye]

One of the things that periodically bites me is forgetting to add a DLL reference to a project. I have written some code to spin the Access collections and report on forms, tabledefs, indexes, relations, etc.

I would like to add a piece to report on DLL's registered via the Tools -> References menu option. That way I can do a quck double check when I copy something out of my toolkit into a different project.

Can someone point me how to do this?

Thanks in advance for any help!

 

[acron]

The following code will report on all references set for the active VBProject :

Sub ShowVBProjRefs()
Dim refVBE
Dim strRefs As String
    For Each refVBE In Application.VBE.ActiveVBProject.References
    strRefs = strRefs & refVBE.GUID & vbTab & refVBE.FullPath & vbCrLf
    Next refVBE
    MsgBox strRefs, Title:="Active VBProject References"
    Set refVBE = Nothing
End Sub

If using Office XP, you may need to change your security settings to allow access to the VBProject via code, as by default such access is disabled.

A.C.

 

[acron]

Sorry,

For a little more info amend the code to :

Sub ShowVBProjRefs()
Dim refVBE
Dim strRefs As String
    For Each refVBE In Application.VBE.ActiveVBProject.References
    strRefs = strRefs & refVBE.Name & vbTab & _
                refVBE.GUID & vbTab & _
                refVBE.FullPath & vbCrLf
    Next refVBE
    MsgBox strRefs, Title:="Active VBProject References"
    Set refVBE = Nothing
End Sub

This includes in actula name of the reference, which might be more informative thann the GUID or Filename.

A.C.

 

[SBendBuckeye]

Hey Acron,

Thanks a lot! That is exactly the type of thing I was looking for. If you send an email to landgwiney@characterlink.net, I'll try to remember to send you a copy of the System Information project I'm working on when I get it done.

Thanks again!