Check out the Workbook.VBProject.References object.

--
Jim Rech
Excel MVP
"mangesh_yadav " wrote in
message ...
| Is there a way to add references automatically through VBA (or any other
| method). For e.g. in the VBA editor, go to TOOLS REFERENCES and click
| any of the references to add it (this is manual).
|
| - Mangesh
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|