Excel VBA Efficient Office from Beginner to Master -( 1CD )

Author: He Fei
Publisher:
Publish Date: 2006-12-01
Features: This book consists of 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 ability to read VBA programs, which will help with the later learning of code examples. This section contains some programming-related 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 through this section, while those with other similar programming experience can quickly master all the fundamental 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 an analysis of the shortcomings of Excel's original functions, this section improves Excel in multiple ways. Some code examples enhance the automation of programs, while others reduce the reader's operational steps, and some programs achieve 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 of them 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 the advanced applications of Excel VBA technology. This section also contains a large number of code examples, which are more powerful and complex, involving file operations, user forms, printing, automation, and data management. Most of them 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 includes 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 accompanying CD-ROM that comes with the book for easy use. It is worth noting that all the code content in this book, except for some Chinese characters, consists of Western symbols. Readers who input the code manually should pay attention to the character format during input. If there are any doubts, they can refer to the source files on the CD-ROM. Each chapter in this book has two sections at the end—summary and exercises—to reinforce learning.