Microsoft Excel 2016 Programming by Example with VBA, XML, and ASP

Microsoft Excel 2016 Programming by Example with VBA, XML, and ASP

by JulittaKorol (Author)

Synopsis

Microsoft Excel 2016 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 2016, this book provides information on performing automatic operations on files, folders, and other Microsoft Office and Web applications. 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.

$50.11

Quantity

20 in stock

More Information

Format: Paperback
Pages: 900
Edition: Pap/Cdr
Publisher: Mercury Learning & Information
Published: 28 Jul 2016

ISBN 10: 1942270852
ISBN 13: 9781942270850
Book Overview: Updated for MS Excel 2016 and previous versions. Includes 30 chapters and more than 275 applied examples and 10 projects. Covers HTML and Office Web Apps. CD with color screen captures, source code, and supplemental files for projects in the text.

Media Reviews
Updated for Excel 2016 this a practical, how-to book on Excel programming is suitable for readers already proficient with the Excel user interface. If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous, illustrated, hands-on exercises. Includes a comprehensive disc with source code, supplemental files, and color screen captures.

More advanced topics are demonstrated via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using Classic ASP pages 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. The 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 guides you through programming advanced Excel features such as PivotTables, PivotCharts, and the Ribbon interface.
--I Programmer
Author Bio
Julitta Korol has published over two dozen computer books on using and programming Microsoft Excel and Microsoft Access. In recent years, she has been supporting and developing database processes and Web applications for a major New York City municipal agency. Ms. Korol has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA). She lives in Long Island, New York.