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.