Excel 2007 Vba Programming With Xml And Asp

This book offers a hands-on approach for those looking to extend and customise 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 customise 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.