Adding to the advice of Jacc if you wish to run solver using a macro you must also set a reference to solver in "Visual Basic" window. Tools -> References and tick box marked solver.

For more specific help you could upload a file with an example of what you wish to achieve.

Alf