Overview
- A brand new guide to Excel VBA using comprehensive step-by-step guides and engaging example applications
- Written by 30-times published author and professional VBA programmer Flavio Morgado
- Includes guidance on how to extend Excel using the Windows API
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (11 chapters)
Keywords
About this book
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.
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Programming Excel with VBA
Book Subtitle: A Practical Real-World Guide
Authors: Flavio Morgado
DOI: https://doi.org/10.1007/978-1-4842-2205-8
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Flavio Morgado 2016
Softcover ISBN: 978-1-4842-2204-1Published: 11 November 2016
eBook ISBN: 978-1-4842-2205-8Published: 09 November 2016
Edition Number: 1
Number of Pages: XXIV, 789
Number of Illustrations: 10 b/w illustrations, 304 illustrations in colour
Topics: Microsoft and .NET, IT in Business, Data Mining and Knowledge Discovery