i do lots of vba with excel.
Perhaps http://www.vivaceproject.com/content/advanced/mdo%5Fframe%5Fexec.pdf
MDO Multidisciplinary Design and Optimisation