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

Julitta Korol (author)

Softcover

ISBN 10: 1942270852 ISBN 13: 9781942270850

Publisher: Mercury Learning and Information, 2016

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.

About this title

Review

"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

About the Author

Since 1993, Julitta Korol (Long Island, NY) has published over two dozen computer books on using and programming Microsoft Excel and Microsoft Access. Ms. Korol has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).

Edition details

• Publisher: Mercury Learning and Information
• Publication date: 2016
• ISBN 10: 1942270852
• ISBN 13: 9781942270850
• Binding: Perfect Paperback
• Language: English
• Number of pages: 1102