Excel 2007 VBA Programming with XML and ASP |
|
Author:
| Korol, Julitta |
ISBN: | 978-0-7637-8276-4 |
Publication Date: | Jun 2009 |
Publisher: | Jones & Bartlett Learning, LLC
|
Book Format: | Ebook |
List Price: | USD $167.85 |
Book Description:
|
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 accss and display data, this book takes you on a progrmming 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...
More DescriptionExcel 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 accss and display data, this book takes you on a progrmming 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.