ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding references automatically (https://www.excelbanter.com/excel-programming/303014-adding-references-automatically.html)

mangesh_yadav[_25_]

Adding references automatically
 
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

--
Message posted from http://www.ExcelForum.com


Jim Rech

Adding references automatically
 
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/
|




All times are GMT +1. The time now is 01:47 PM.

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