Setting up function development in Excel 2007

One of the toughest development tasks in Exstream Dialogue development is the development and testing of functions in Dialogue Manager.  Programming a function and testing the returned value using the test icon can be time consuming; also Dialogue version 6 also had the habit of crashing on the second execution!  Thankfully this problem has been solved in Version 7.0, but most of us usually move our testing of a function to Excel.  Excel has the most accessible implementation of VBA within the Microsoft Office Suite of applications.  It's also been pretty easy to attach a function to a long column of cells and feed a column of cells into the function to test a function. 

Although this approach has been relatively straightforward for years, Excel has changed the way that functions are created and stored, starting with Excel 2007.  If you have switched from Office 2003, you are in for a shock.  Luckily, John Green has  Excel 2007 VBA Programmer's Reference (Programmer to Programmer).  This reference takes you beyond the usual "For Dummies" approach to VBA.  This book should get you over the 2003 to 2007 hump, and provide Exstream Dialogue developers a useful resource as the missing VBA manual.  Now if HP would finally implement Try Catch Throw ....