Excel 2007 VBA Programming with XML and ASP (Paperback, New Ed)

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.