Excel VBA Efficient Office Skills: From Beginner to Expert

Author: He Fei
Publisher:
Publish Date: 2006-12-01
Features: This book includes 16 chapters, which can be divided into the following sections. Section 1 includes Chapters 1–3, explaining the basic knowledge required for applying Excel VBA technology. The focus is on the VBA language, covering its syntax, common statements, procedures, and object concepts. Through this section, readers should gain a preliminary understanding of reading VBA programs, which will help with the later learning of code examples. This section contains some programming content, but it has been trimmed to an easy-to-learn level. Readers with no programming experience can still get a basic understanding of computer programming techniques through this section, while those with other similar programming experience can quickly master the essential basic knowledge required for using Excel VBA technology in a short time. Section 2 includes Chapters 4–10, covering the primary applications of Excel VBA technology. Based on analyzing the shortcomings of Excel's original functions, this section improves Excel in multiple aspects. Some code examples enhance the automation of programs, some reduce reader operations, and others implement functions that Excel originally lacked. Through this section, readers should be able to use Excel VBA technology to improve Excel's existing functions and make it more suitable for their work. All the code examples in this section come from real-world scenarios and are highly representative, so most can be directly applied to practical work. Some code examples only require minor modifications to be more effective. Section 3 includes Chapters 11–16, covering advanced applications of Excel VBA technology. This section also includes numerous code examples, which are more powerful and complex, covering topics such as file operations, user forms, printing, automation, and data management. Most of these expand on functions that Excel itself does not have, such as file system access and printing. Through this section, readers should be able to flexibly use VBA technology to complete various complex functions, even control every aspect of the Excel application, and become experts in Excel VBA technology. This section contains many valuable code examples, many of which are urgently needed by readers but difficult to implement. All the code examples cited in this book are placed on the companion CD that comes with the book for easy use. It is important to note that all the code content in this book, except for some Chinese characters, is in Western characters. Readers who input the code manually should pay attention to the character format when typing. If there are any doubts, they can refer to the source files on the CD. Each chapter in this book has two sections at the end—summary and exercises—to reinforce learning.