VBA for the 2007 Microsoft Office system

VBA for the 2007 Microsoft Office system

“VBA for the 2007 Microsoft Office System is jam-packed with code samples that you’ll be able to reuse right away in your VBA projects.” —Guy Barrette, Microsoft MVP & Regional Director, .NET Expertise Develop your VBA expertise instantly with proven techniques VBA for the 2007 Microsoft® Office...

Descripción completa

Detalles Bibliográficos
Otros Autores: McFedries, Paul Author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] Que 2007
Edición:1st edition
Colección:Business solutions
Materias:
Microsoft Office.
Microsoft Visual Basic for applications.
Business > Computer programs.
Integrated software.
Marketing & Sales
Commerce
Business & Economics
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627080506719
Tabla de Contenidos:
  • Cover
  • Contents
  • Introduction
  • What Is a Macro?
  • What Does VBA Have to Do with Macros?
  • What You Should Know Before Reading This Book
  • What's in the Book
  • This Book's Special Features
  • I: GETTING STARTED WITH VBA
  • 1 Creating and Running Recorded Macros
  • Recording a VBA Macro
  • Running a Recorded Macro
  • 2 Writing Your Own Macros
  • Activating the Ribbon's Developer Tab
  • Displaying the Visual Basic Editor
  • Touring the Visual Basic Editor
  • Understanding VBA Procedures
  • Creating a Command Macro
  • Creating a User-Defined Function
  • Taking Advantage of IntelliSense
  • Shutting Down the Visual Basic Editor
  • 3 Understanding Program Variables
  • Declaring Variables
  • Avoiding Variable Errors
  • Variable Data Types
  • Using Array Variables
  • Working with Constants
  • Storing User Input in a Variable
  • 4 Building VBA Expressions
  • Understanding 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
  • What Is an Object?
  • 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
  • 6 Controlling Your VBA Code
  • Code That Makes Decisions
  • Using If...Then to Make True/False 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
  • Indenting for Readability.
  • II: PUTTING VBA TO WORK
  • 7 Programming Word
  • Working with Documents
  • Working with Text
  • Working with the Range Object
  • Using the Selection Object
  • Using the Words Object
  • Working with the Sentences Object
  • Programming the Paragraph Object
  • 8 Programming Excel
  • Excel's Application Object
  • Manipulating Workbook Objects
  • Dealing with Worksheet Objects
  • Working with Range Objects
  • 9 Programming PowerPoint
  • PowerPoint's Presentation Object
  • Working with PowerPoint Slide Objects
  • Dealing with Shape Objects
  • Operating a Slide Show
  • 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
  • 11 Programming Outlook Email
  • Getting Started
  • Working with Outlook Folders
  • Handling Incoming and Outgoing Messages
  • Working with Email Messages
  • Sending a Message
  • Working with Attachments
  • Programming Outlook from Other Applications
  • III: GETTING THE MOST OUT OF VBA
  • 12 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
  • 13 Customizing the Office 2007 Ribbon
  • Understanding Ribbon Extensibility
  • Extending the Ribbon: An Example
  • Hiding the Built-In Ribbon
  • Creating Custom Tabs
  • Creating Custom Groups
  • Creating Custom Controls
  • 14 VBA Tips and Techniques
  • Working with Modules
  • Configuring Macro Security Settings
  • Digitally Signing a VBA Project
  • Saving Application Settings in the Registry
  • Accessing the File System Through VBA
  • Tips for Faster Procedures
  • 15 Trapping Program Errors
  • A Basic Error-Trapping Strategy
  • Working with the Err Object
  • Trappable VBA Errors.
  • 16 Debugging VBA Procedures
  • A Basic Strategy for Debugging
  • Pausing a Procedure
  • Stepping Through a Procedure
  • Monitoring Procedure Values
  • Using the Immediate Window
  • Debugging Tips
  • IV: APPENDIXES
  • A: VBA Statements
  • B: VBA Functions
  • Index.

Ejemplares similares