Programatically access Excel's Solver?

[Kevin R]

I have a spreadsheet that uses the Excel Solver. I have a vb program that
refreshes this spreadsheet. I have a number of Solver Parameter ranges that
need to be tweaked each time the data changes. Can I modify Solver
Parameters via vb code?

Thanks for any pointers on where to find information on this.

Kevin

 

[Tom Ogilvy]

Turn on the macro recorder and perform the changes manually. Turn off the
recorder and look at the code. This should give you a good indication of
what you can do. Also see this article:


Creating Visual Basic Macros that Use Microsoft Excel Solver
http://support.microsoft.com/support/Excel/Content/Solver/SOLVER.asp

 

[Steve Dalton]

Yes. You need to add a reference to Solver (in VBE... Tools/References...).
You can find help for the VB functions via a search on the MS website (try
MDSN). Once you've done that, you can link specific solver operations to
embedded control objects or even workbook or worksheet events.

If you can't find what you need let me know and I'll dig out more detail.

Regards

Steve Dalton

 

[Kevin R]

Thank you for the responses.

Kevin