Good resources for learning about Solver & macros?

Hi,

Can anyone refer me to some good books or websites that specialize in Solver and macros/VBA? I've never used VBA before, but I really need to learn it so I can find ways to improve my optimization model.

Any references would be much appreciated.

Thanks!
jILL

Originally Posted by jhatcher19

Hi,

Can anyone refer me to some good books or websites that specialize in Solver and macros/VBA? I've never used VBA before, but I really need to learn it so I can find ways to improve my optimization model.

Any references would be much appreciated.

Thanks!
jILL

download free pdf book for VBA from link below.

http://www.oebook.com/{65574750-EC24...809C42FC0}.htm

you can browse this web for more books.

Regards.

2 of my favourites

1) Anything written by John Walkenbach. Also his website http://j-walk.com/ss/

2) this site http://www.cpearson.com/excel/topic.htm

Matt