Microsoft Excel VBA Programming for the Absolute Beginner

Duane Dirnbaum - Collection Absolute Beginner

490 pages, parution le 30/03/2005 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

Written specifically with the beginner in mind, Microsoft Excel VBA for the Absolute Beginner, Second Edition is the follow up to the most successful and best selling title in the Absolute Beginner series. It contains completely updated information written for Excel 2003. It is geared towards students taking introductory programming courses, as well as professionals who frequently use spreadsheets and want to expand their knowledge of the capabilities of Excel by writing their own programs. An ideal introduction to programming techniques, it concentrates on introductory programming topics and good programming practices, using the VBA Excel language and the creation of simple games to reinforce each new skill.

Features

Geared towards beginning programmers, whether students or professionals, who have a basic understanding of the Excel application.

Readers will learn how to program using VBA as it applies to Microsoft Excel as they are guided through several programming concepts common to any programming language.

Each chapter contains small code snippets and programs to illustrate the chapter topic and concludes with the development of a larger program based on a simple game, making beginning programming fun and accessible.

Teaches the reader how to write useful applications for data analysis in Excel for use with workbooks, worksheets, ranges, and formulas, charts, menus and toolbars, and Microsoft Access databases.

L'auteur - Duane Dirnbaum

Duane Birnbaum began programming in graduate school, where he wrote custom software for interfacing the various electronic devices require for his experiments and analyzing the data obtained from them. Since completing his Ph.D. in physical chemistry, he has worked in academia and the biotech industry while continually teaching on a part-time basis. He has been serving as a part-time lecturer in computer science at Indiana University/Purdue University Indianapolis for seven years teaching courses in programming, data analysis, and database design.

Sommaire

Introduction
Visual basic for Applications with Excel
Beginning Programs with VBA
Procedures and Conditions
Loops and Arrays
Basic Excel Objects
VBA UserFoms and Additional Controls
Error Handling, Debugging, and Basic File I/O
Using XML with Excel-VBA Projects
Excel Charts
VBA Shapes
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Thomson - Course Technology
Auteur(s)	Duane Dirnbaum
Collection	Absolute Beginner
Parution	30/03/2005
Édition	2^eme édition
Nb. de pages	490
Format	18,5 x 23
Couverture	Broché
Poids	1020g
Intérieur	Noir et Blanc
EAN13	9781592007295
ISBN13	978-1-59200-729-5