List of references for compiled .mde's

A

AA

How can i get a list of references that my compiled Mde
uses, I'd like to get the full path name, the reference
wizard is unable to show the complete path.

or,

How can i compare the references my .mde uses versus the
available references on the host computer??

my company has poorly managed their upgrades and im
trying to make sure all users use the correct references
i intended. (unfortunaley i dont have the packaging
wizard to do this...)

thanks!
 
D

Douglas J. Steele

Sub ListReferences()
On Error Resume Next

Dim refCurr As Reference

For Each refCurr In Application.References
If refCurr.IsBroken = True Then
Debug.Print "Broken Reference: " & refCurr.GUID
Else
Debug.Print refCurr.Name & ": " & refCurr.FullPath
End If

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top