Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross 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

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?
 
Replies continue below

Recommended for you

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

Part and Inventory Search

Sponsor

Back
Top Bottom