Adding references automatically

[mangesh_yadav]

Is there a way to add references automatically through VBA (or any othe
method). For e.g. in the VBA editor, go to TOOLS > REFERENCES and clic
any of the references to add it (this is manual).

- Manges

 

[Jim Rech]

Check out the Workbook.VBProject.References object.

--
Jim Rech
Excel MVP
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
|