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!

Register Log in
  • 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?
 
Sort by date Sort by votes
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!

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BhagyeshVashi
  • Locked
  • Question Question
Need a rename macro for excel
Replies
11
Views
1K
sdz
sdz
Tuckabag
  • Locked
  • Question Question
Acessing CMD shell in Excel/VBA with keystrokes and copying resultant data
Replies
8
Views
1K
3DDave
3DDave
vinodnx7
  • Locked
  • Question Question
count the same text from the file and create new list with number
Replies
19
Views
1K
vinodnx7
vinodnx7
Kenja824_home
  • Locked
  • Question Question
Excel - Looking for a formula please
Replies
14
Views
1K
BridgeSmith
BridgeSmith
Kenja824
  • Locked
  • Question Question
excel Formula Find help
Replies
5
Views
1K
Kenja824
Kenja824

Part and Inventory Search

Sponsor

Back
Top