Late binding could be an option for the long-term, but at the moment i
is not solving my immediate problem.

How do I list the active references.

- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27309

Sub ShowReferences()
Dim ref As Object
For Each ref In ThisWorkbook.VBProject.References
Debug.Print ref.FullPath, ref.Name
Next
End Sub

--
Regards,
Tom Ogilvy

"mangesh_yadav" wrote in
message ...

Late binding could be an option for the long-term, but at the moment it
is not solving my immediate problem.

How do I list the active references.

- Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=273090