Flylib.com
Absolute Beginners Guide to VBA
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
Year: 2003
Pages: 146
Authors:
Paul McFedries
BUY ON AMAZON
Absolute Beginner s Guide to VBA
Table of Contents
Copyright
About the Author
Acknowledgments
We Want to Hear from You
Introduction
What You Should Know Before Reading This Book
This Book s Special Features
Part I: Getting Started with VBA
Chapter 1. Recording Your First Macro
What Is a Macro?
Recording a VBA Macro
Chapter 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
Chapter 3. Understanding Program Variables
Declaring Variables
Avoiding Variable Errors
Variable Data Types
Using Array Variables
Working with Constants
Chapter 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
Chapter 5. Working with Objects
The Object Hierarchy
Working with Object Properties
Working with Object Methods
Handling Object Events
Working with Object Collections
Assigning an Object to a Variable
The Is Operator
Working with Multiple Properties or Methods
Example: The Application Object
Example: The Window Object
Chapter 6. Controlling Your VBA Code
Code That Makes Decisions
Using If...Then to Make TrueFalse Decisions
Using If...Then...Else to Handle a False Result
Making Multiple Decisions
Functions That Make Decisions
Code That Loops
Using Do...Loop Structures
Using For...Next Loops
Using For Each...Next Loops
Using Exit For or Exit Do to Exit a Loop
Part II: Putting VBA to Work
Chapter 7. Programming Word
Working with Documents
Working with Text
The Range Object
The Selection Object
The Characters Object
The Words Object
The Sentences Object
The Paragraph Object
Chapter 8. Programming Excel
Excel s Application Object
Manipulating Workbook Objects
Dealing with Worksheet Objects
Working with Range Objects
Chapter 9. Programming PowerPoint
PowerPoint s Application Object
PowerPoint s Presentation Object
Working with PowerPoint Slide Objects
Dealing with Shape Objects
Operating a Slide Show
Chapter 10. Programming Access Databases
Getting Ready: Two Steps Before You Begin
Working with Database Records: Opening a Recordset
Working with a Recordset
Retrieving Data into Excel
Chapter 11. Programming Outlook Email
Working with Outlook Folders
Working with Email Messages
Sending a Message
Working with Attachments
Programming Outlook from Other Applications
Part III: Getting the Most Out of VBA
Chapter 12. Interacting with the User
Programming Sounds
Displaying Information to the User
Getting Input from the User
Chapter 13. Creating Custom VBA Dialog Boxes
Adding a Form to Your Project
Changing the Form s Design-Time Properties
Working with Controls
Handling Form Events
Types of Form Controls
Using a Form in a Procedure
Chapter 14. Creating Custom Menus and Toolbars
Assigning Macros to Menu Commands
Creating Custom Toolbars for Your Macros
Menus, Toolbars, and VBA
Understanding Command Bars
Working with Command Bar Controls
Chapter 15. Debugging VBA Procedures
Trapping Program Errors
A Basic Strategy for Debugging
Pausing a Procedure
Stepping Through a Procedure
Monitoring Procedure Values
Using the Immediate Window
Debugging Tips
Part IV: Appendixes
Appendix A. VBA Statements
Appendix B. VBA Functions
Index
index_SYMBOL
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J
index_K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
Year: 2003
Pages: 146
Authors:
Paul McFedries
BUY ON AMAZON
Interprocess Communications in Linux: The Nooks and Crannies
Linking Object Code
Summary
Creating a Message Queue
Summary
Peeking at Data
Beginning Cryptography with Java
Message Digests, MACs, and HMACs
Object Description in Cryptography Using ASN.1
Certificate Revocation and Path Validation
CMS and S/MIME
Appendix A Solutions to Exercises
Managing Enterprise Systems with the Windows Script Host
Introduction
Logon Scripts and Scheduling
Registry Operations
Internet Information Server
Security
Twisted Network Programming Essentials
Building Simple Clients and Servers
Uploading a File
Enabling Web Services Using XML-RPC
Authentication
Using Public Keys for Authentication
Microsoft WSH and VBScript Programming for the Absolute Beginner
Constants, Variables, and Arrays
Conditional Logic
Processing Collections of Data
Handling Script Errors
Using the Windows Registry to Configure Script Settings
.NET-A Complete Development Cycle
Design of the Image-Processing Components Using Late Binding
Unit Tests
Database Access with ADO.NET
Deployment
Requirements Tracing
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies