Saving VBA references between startups

[happohippo]

Hi.

I am referencing Microsoft Scripting Runtime in my VBA code because I use dictionaries. However, this reference reset after every startup. How can I retain this between startups so that I only need to activate it once? Or better yet is there a way to do this inside the code similar to "normal" programming languages? I would like my VBA project to be usable by other people and it seems cumbersome for them to require to check the reference on every startup.

My problem must have an answer somewhere but I cannot seem to find it here, on Stackoverflow or general internet. It seems like such a basic problem.

 

[RoryA]

References are saved with the workbook, so other users of your workbook would not have to set them. If you use that with every workbook, you'd have to create a template with the reference set and use that as your default template. Or late bind your code so that you don't need the reference at all.