Visual Basic for Applications (VBA) is a set of tools based on the Visual Basic language. The great thing about using it to enhance Office applications is that it's easier to learn than Visual Basic and it comes with your Office license. After reading this book, the reader will be proficient in the VBA language and will have extensive knowledge of the Office 2003 Object Model. This book will cover all features of the VBA editor and show how to program some of the more useful new features in the Office 2003 applications.This book assumes no prior programming experience, so even programming novices can get up to speed quickly on the basics of the VBA language. It is very practical and offers the reader tested programs and projects that he or she can implement right away. This book reinforces the reader's learning by presenting useful, end-of-chapter pedagogical resources, including question-and-answer sessions and quizzes, as well as practical exercises that cement and extend the reader's knowledge. It explorers not only the object models of Word and Excel, but also other members of the Office 2003 suite, including PowerPoint, Access, and Outlook.
- Limba : Engleza
- Cuprins :
I. GETTING STARTED WITH VBA.1. Recording Your First Macro.
What Is a Macro? Recording a VBA Macro. 2. Writing Your Own Macros.
Displaying the Visual Basic Editor. Touring the Visual Basic Editor. Writing Your Own Command Macro. Running a VBA Macro. Creating User-Defined Functions with VBA. Working with Procedures. Working with Modules. Shutting Down the Visual Basic Editor. 3. Understanding Program Variables.
Declaring Variables. Avoiding Variable Errors. Variable Data Types. Using Array Variables. Working with Constants. 4. Building VBA Expressions.
Working with VBA Operators. Understanding Operator Precedence. Working with Numeric Expressions. Working with String Expressions. Working with Logical Expressions. Working with Date Expressions. 5. Working with Objects.
The Object Hierarchy. Working with Object Properties. Working with Object Methods. Handling Object Events. Working with Object Col
- Data Publicarii : 2004
- Editie : 1
- Format : Paperback
- Numar pagini : 384
- ISBN : 9780789730763