Why Do People Add a Reference To XLA's Dynamically?

Just wondering why projects like solver.xla get added via VBA

I ve seen a number of projects do this in the past - What does it buy you that a开发者_运维技巧dding it via the menu does not.

It's easier to do it programatically than to try to instruct the user how to add it using the menu, especially when you consider the interface differences between excel 2003 and 2007.