Microsoft Excel 2002 Visual Basic for Applications

Step by step

Reed Jacobson - Collection Step by Step

306 pages, parution le 29/11/2001

Ajouter à une liste

Indisponible

Résumé

Teach yourself just what you need to know about developing with Excel Version 2002 Visual Basic for Applications. This title, aimed at beginner developers, is a teach-yourself guide to creating custom software solutions, automating tasks, and taking creative control of Excel Version 2002 by exploiting its built-in programming language, Microsoft Visual Basic for Applications (VBA). You'll learn to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more. The popular Step-by-Step method lets you choose your best starting point, and the easy-to-follow lessons include clear objectives and real-world business examples so you can learn exactly what you need to know, at your own speed. Prepared by an author with extensive knowledge of VBA and Excel, this book includes numerous screen shots that illustrate specific step-by-step programming procedures, plus a companion CD-ROM full of practice files that are tightly integrated with the lessons.

Table of Contents

Introduction
Getting Help
Using the Book's CD-ROM
Checking Your Configuration
Conventions and Features
Automating Everyday Tasks
Make a Macro Do Simple Tasks
Make a Macro Do Complex Tasks
Exploring Objects
Explore Workbooks and Worksheets
Explore Graphical Objects
Explore Range Objects
Explore PivotTable Objects
Exploring Visual Basic
Control Visual Basic
Extend Excel and Visual Basic
Making Macros Easy to Use
Launch Macros with Events
Use Dialog Box Controls on a Worksheet
Create a Custom Form
Create an Enterprise Information System
Index

L'auteur - Reed Jacobson

Reed Jacobson is Vice President, Consulting for LEX Software, a company that specializes in custom development services using Microsoft Excel, Visual Basic, SQL Server, and other products. LEX Software is one of the original companies invited to participate in what later became the Microsoft Solution Provide Program. Reed received a B.A. in Japanese and Linguistics, and MBA from Brigham Young University, and a graduate fellowship in Linguistics from Cornell University. He worked as a Software Applications Specialist for Hewlett-Packard for 10 years and ran his own consulting firm for five years.

Reed is the author of Excel Trade Secrets for Windows, Microsoft Excel Advanced Topics Step by Step, and Office 2000 Expert Companion. He has given presentations on Excel at TechEd and other Microsoft conferences and seminars.

Autres livres de Reed Jacobson

Microsoft Excel 2007 VBA - Etape par étape - Pro

Découvrir tous les livres de Reed Jacobson

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Reed Jacobson
Collection	Step by Step
Parution	29/11/2001
Nb. de pages	306
Format	18,8 x 23,5
Couverture	Broché
Poids	740g
Intérieur	Noir et Blanc
EAN13	9780735613591
ISBN13	978-0-7356-1359-1