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

· Mercury Learning and Information
Ebook
800
Pages
Eligible
Ratings and reviews aren’t verified  Learn More

About this ebook

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. Microsoft Excel 2013 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. The chapters are 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.

Features:
  • Explores in great detail the latest version of Excel and all of its features.
  • Covers recording and editing a macro and writing VBA code through working with XL documents and using ASP to display data on the Web.
  • Covers Office Web Apps.
  • About the author

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

    Rate this ebook

    Tell us what you think.

    Reading information

    Smartphones and tablets
    Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.
    Laptops and computers
    You can listen to audiobooks purchased on Google Play using your computer's web browser.
    eReaders and other devices
    To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.