View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Snidow Greg Snidow is offline
external usenet poster
 
Posts: 153
Default Automatically load solver reference library

Greetings. I have a macro that runs solver. Every time I switch between my
work computer (Excel 2003) and my personal one (Excel 2007) the solver
reference library needs to be loaded again. When I first open the reference
list, solver is not an option. If I first run solver using the toolbar
menus, it will then appear in the reference list and I can select it, no
problem until I switch computers. How can I get it to load the library
automatically, depending on which version of Excel I am using? Thank you.

Greg