Using the Solver with VBA/Macroon Excel

Posted by Steve Scanio on October 25, 2001 11:34 AM

Mr. Excel,

I need some help. I have Excel 2000 and recorded a macro that involved using the "solver".

When I run the macro, it either tells me that there is a syntex error and it highlights the first line of macro, i.e.SolverGet() or another error I had received was sub or function not defined.

This used to ork for me in Excel 95, what could be the problem?

Steve

P.S. I know very little VBA, so please go gentle on me

Posted by Damon Ostrander on October 25, 2001 12:10 PM

Hi Steve,

The most likely problem is that Solver's references aren't loaded. In the VBE go to Tools -> References, then check the SOLVER checkbox.

Happy solving.

Damon

Posted by Steve Scanio on October 25, 2001 2:00 PM

Re: Using the Solver with VBA/Macros in Excel 2000

I tried Damon's suggestion, but the references tab is not highlighted, so I can choose this option.

Where do I go next?

Posted by Steve Scanio on October 25, 2001 2:12 PM

Re: Using the Solver with VBA/Macros Excel

I figure out what I did wrong, I was not in the Design Mode.

Thanks so much Damon!!!