Microsoft® EXCEL® 2010 Programming By Example

with VBA, XML, and ASP

Julitta Korol

ISBN: 9781936420032
Pub Date:  August 5, 2011
Specs: 7 x 9   Paperback with CD
Pages: 800
Price: $49.95

Microsoft Excel 2010 Programming by Example with VBA, XML and ASP is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface.  The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects.  From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Thirty chapters loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it.  Each exercise/project step is clearly explained as it is performed. 

Julitta Korol is a software consultant who delivers custom-tailored hands-on training and develops advanced database and spreadsheet applications. She has written a dozen computer books including Microsoft Access 2010 with VBA, XML and ASP (Mercury Learning). She lives on Long Island, New York.

SHORT DESCRIPTION OF BOOK:

This book is suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercises. More advanced topics are introduced via custom projects.  Covers recording and editing a macro and writing VBA code through working with XML documents and using ASP to display data on the Web.