Excel 2007 VBA Programming with XML and ASP offers a hands-on approach for those looking to extend and customize Excel functionality. From recording a simple macro and writing VBA code to working with XML documents and using ASP to access and display data, this book takes you on a programming journey that will change the way you work with Excel! Learn how to: Automate spreadsheet tasks with macros. Write VBA code to program PivotTables, generate charts, build dialog boxes, and customize the Ribbon. Handle errors and debug programs. Create hyperlinks and publish HTML files. Retrieve data from the web directly into Excel. Develop and manipulate smart tags using XML.