View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
expatgr expatgr is offline
external usenet poster
 
Posts: 1
Default Calling Solver from an Excel 2003 Macro

When I use Solver manually in my spreadsheet it works as
expected. When I call it from a macro, I get an VBA
error saying that a subroutine or function is not
referenced. When I go to Tools - References I can't
find Solver.XLA in the tick box list of Addins. Does
anyone know how to force Excel to update this list, to
include the Solver Addin?