Programming Excel with VBA

A Practical Real-World Guide

Business & Finance, Industries & Professions, Information Management, Nonfiction, Computers, General Computing, Programming
Cover of the book Programming Excel with VBA by Flavio Morgado, Apress
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Flavio Morgado ISBN: 9781484222058
Publisher: Apress Publication: November 9, 2016
Imprint: Apress Language: English
Author: Flavio Morgado
ISBN: 9781484222058
Publisher: Apress
Publication: November 9, 2016
Imprint: Apress
Language: English

Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-by-step guidance, example applications, and screenshots in Excel 2016.

In this book, you will learn:

  • How to interact with key Excel objects, such as the application object, workbook object, and range object

  • Methods for working with ranges in detail using code

  • Usage of Excel as a database repository

  • How to exchange data between Excel applications

  • How to use the Windows API to expand the capabilities of Excel

  • A step-by-step method for producing your own custom Excel ribbon

Who This Book Is For:

Developers and intermediate-to-advanced Excel users who want to dive deeper into the capabilities of Excel 2016 using code.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-by-step guidance, example applications, and screenshots in Excel 2016.

In this book, you will learn:

Who This Book Is For:

Developers and intermediate-to-advanced Excel users who want to dive deeper into the capabilities of Excel 2016 using code.

More books from Apress

Cover of the book Learn Unity 2017 for iOS Game Development by Flavio Morgado
Cover of the book JavaFX 9 by Example by Flavio Morgado
Cover of the book MATLAB Differential and Integral Calculus by Flavio Morgado
Cover of the book Models to Code by Flavio Morgado
Cover of the book Pro Processing for Images and Computer Vision with OpenCV by Flavio Morgado
Cover of the book Spinning Up ServiceNow by Flavio Morgado
Cover of the book The Handbook of Financial Modeling by Flavio Morgado
Cover of the book Practical Information Security Management by Flavio Morgado
Cover of the book Pivotal Certified Spring Enterprise Integration Specialist Exam by Flavio Morgado
Cover of the book HTML5 Quick Markup Reference by Flavio Morgado
Cover of the book Practical Graph Analytics with Apache Giraph by Flavio Morgado
Cover of the book Practical SharePoint 2013 Enterprise Content Management by Flavio Morgado
Cover of the book PHP Persistence by Flavio Morgado
Cover of the book Pro Oracle GoldenGate for the DBA by Flavio Morgado
Cover of the book Web Development with Go by Flavio Morgado
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy