Book description
Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web site, www.mrexcel.com, this book is sure to save you time and money!
Table of contents
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- About the Authors
- Dedication
- Acknowledgments
- We Want to Hear from You!
- Introduction
- I First Steps up the VBA Learning Curve
- II Automating Excel Power in VBA
-
III Techie Stuff You Will Need to Produce Applications for the Administrator to Run
- 17 Arrays
- 18 Text File Processing
- 19 Using Access as a Back End to Enhance Multi-User Access to Data
- 20 Creating Classes, Records, and Collections
- 21 Advanced UserForm Techniques
- 22 Windows Application Programming Interface (API)
- 23 Handling Errors
- 24 Using Custom Menus to Run Macros
- 25 Add-Ins
- 26 Case Study: Designing an Excel Application
- Index
Product information
- Title: VBA and Macros for Microsoft Excel
- Author(s):
- Release date: May 2004
- Publisher(s): Que
- ISBN: 0789731290
You might also like
book
Microsoft Excel 2019 VBA and Macros, First Edition
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, …
book
Excel 2013 Power Programming with VBA
Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, …
book
Excel 2016 VBA and Macros
This is the Rough Cut version of the printed book. SAVE TIME AND SUPERCHARGE EXCEL 2016 …
video
Visual Basic for Microsoft Excel
In this VB for Excel training course, you will learn how to apply the VBA programming …