ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting References in VBA (https://www.excelbanter.com/excel-programming/296197-setting-references-vba.html)

Todd Huttenstine[_3_]

Setting References in VBA
 
IN VBA when I go to reference and reference a new library, why does it not
stay there for when the next time open Excel?



Dave Peterson[_3_]

Setting References in VBA
 
References are set for each workbook.

If you set a reference to a workbook, save and close it, and then reopen it, it
should still be there.



Todd Huttenstine wrote:

IN VBA when I go to reference and reference a new library, why does it not
stay there for when the next time open Excel?


--

Dave Peterson


Todd Huttenstine[_3_]

Setting References in VBA
 
Guess Im so used to working with the same projects over and over I assumed
references were saved in the actual program itself. Makes sense. Thanx.


"Dave Peterson" wrote in message
...
References are set for each workbook.

If you set a reference to a workbook, save and close it, and then reopen

it, it
should still be there.



Todd Huttenstine wrote:

IN VBA when I go to reference and reference a new library, why does it

not
stay there for when the next time open Excel?


--

Dave Peterson





All times are GMT +1. The time now is 05:27 PM.

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