Excel 2007 VBA Programming With XML & ASP

Excel 2007 Programming by Example 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.