ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Compile Errors and Missing references (https://www.excelbanter.com/excel-programming/315015-compile-errors-missing-references.html)

mangesh_yadav[_147_]

Compile Errors and Missing references
 

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


Tom Ogilvy

Compile Errors and Missing references
 

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





All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com