Excel VBA Efficient Office From Beginner to Master

Author: He Fei
Publisher:
Publish Date: 2006-12-01
Features: This book includes 16 chapters, which can be divided into the following parts. Part 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 have a preliminary understanding of reading VBA programs, which will help with the later study of code examples. This part 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. For those with other similar programming experience, this part can help you quickly master all the basic knowledge required for using Excel VBA technology in the shortest time. Part 2 includes Chapters 4–10, covering the primary applications of Excel VBA technology. Based on analyzing the shortcomings of Excel's original functions, this part improves Excel from multiple aspects. Some code examples enhance the automation of programs, while others reduce the reader's operations, and some programs implement functions that Excel originally did not have. Through this section, readers should be able to use Excel VBA technology to improve Excel's original functions, making it more suitable for their work. All the code examples in this part come from real work scenarios and are highly representative, so most can be directly applied to practical work. Some code examples only need minor modifications to be more effective. Part 3 includes Chapters 11–16, covering the advanced applications of Excel VBA technology. This part also includes a large number of code examples, which are more powerful and complex, involving file operations, user forms, printing, automation, data management, and more. Most of them expand 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 all aspects of the Excel application, and become experts in Excel VBA technology. This part 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 worth noting that all the code content in this book, except for some Chinese characters, is in Western characters. Readers who manually input code should pay attention to the character format when typing. If there are any doubts, you 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.