The book then explains how to include a subroutine in the Excel menu system and change a set of interrelated VBA macros into Excel add-in package. Excel 2007 VBA Macro Programming shows you how to: Write and debug VBA code Creating a custom dialog box and the Maximize button to the Excel object model to Write code to interact with the database add functionality to your programs with a class module API callsInsert Develop custom menu for objects and manipulate ExcelCreate RibbonAnimate in Pivot Tables in calculating VBAExpand and Create full search function add-in Excel VBA Use for working with XML files