VBA and Macros for Microsoft Excel

Bill Jelen, Tracy Syrstad - Collection Business solutions

548 pages, parution le 16/06/2004

Ajouter à une liste

Indisponible

Résumé

There are an estimated 400 million Excel users. Many are Excel power users, but far fewer have figured out how to effectively use Excel VBA. This book is designed to get Excel users up and running with Excel VBA. Many Excel users are frustrated when they record their own macros with the macro recorder, only to discover that the macros won't work exactly right the next day.

This book explains the shortcomings of the macro recorder, but also covers how to take the recorded code and turn it into something really useful. Once you are over that hurdle, the book explains how to understand the object-oriented Visual Basic for Applications Language.

This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.

See VBA syntax in easy-to-understand English
Automate Excel's power tools: Pivot Tables, Charts, Advanced Filters
Save hours per week by automating redundant tasks
Dramatically increase your efficiency with Excel

L'auteur - Bill Jelen

Plus connu aux États-Unis sous le nom de Mister Excel, Bill Jelen. a bâti sa réputation en écrivant plusieurs livres sur le tableur de Microsoft, et en fondant une maison d'édition consacrée aux applications Office. Invité régulièrement à l'émission de télévision américaine TV's Call for Help, il produit un podcast vidéo quotidien sur Excel. Son site mrexcel.com compte 10 millions de pages vues par an.

Autres livres de Bill Jelen

Analyse marketing et reporting avec excel

Découvrir tous les livres de Bill Jelen

Sommaire

First steps up the VBA learning curve
Automating Excel Power in VBA
Techie stuff you will need to produce applications for the administrator to run

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Que
Auteur(s)	Bill Jelen, Tracy Syrstad
Collection	Business solutions
Parution	16/06/2004
Nb. de pages	548
Format	18,5 x 23
Couverture	Broché
Poids	965g
Intérieur	Noir et Blanc
EAN13	9780789731296
ISBN13	978-0-7897-3129-6