Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Evoking the Excel "solver" from a VBA macro

  • Thread starter Thread starter -
  • Start date Start date
Status
Not open for further replies.

Guest
Can anyone tell me how I can run solver from a VBA macro?? I have tried using the "record macro" technique and have not had success when trying to run the macro. Has anyone done this before?
 
You have to check mark SOLVER in VBA - tools-references. If you cannot find SOLVER on the provided list then search for solver.xla (not DLL!) on your computer. Good luck!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top