Authors:
- 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
Buy it now
Buying options
Tax calculation will be finalised at checkout
Other ways to access
This is a preview of subscription content, log in via an institution to check for access.
Table of contents (11 chapters)
-
Front Matter
-
Back Matter
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
-
Rio de Janeiro, Brazil
Flavio Morgado
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