Replicate excel solver code

[jmersing]

I would like to apply the logic of Excel's Solver in Access. The solver model works for small applications but I'd like to use tables to supply data for the solver and execute it through code.

Just wondering if anyone has tried that before.

Thanks

 

[SydneyGeek]

I'm not sure you would get Solver to run in Access because it's an Excel add-in. The most likely answer would be to pull date from Access (filtered, so you don't blow teh row limit) and run the Solver from Excel as normal.

There aren't too many examples around that show how to code the Solver if you want to automate it, but VBA For Modelers (S. Christian Albright) does have some useful stuff. If you want to pull filtered data from Access to Excel, check out this tutorial.

Denis

 

[jmersing]

Thanks Sydney