Thanks. That's funny. I actually have this book, lent it to someone and never got it back, so I had forgotten that this was in there.Quote from JGB:
Take a look at Chapters 11 and 12 of:
"Option Pricing Models and Volatility Using Excel-VBA"
by ROUAH and VAINBERG
ISBN: 978-0-471-79464-6
They provide VBA code for this purpose.