Brilliant Microsoft Excel 2007 VBA & Macros

Bill Jelen (Autor)

Buch | Softcover

624 Seiten

2007
Pearson Prentice Hall (Verlag)
978-0-273-71405-7 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

There are an estimated 400 million Excel users, very few of whom know how to use Excel VBA effectively. This book is designed to get Excel users up and running with Excel VBA. Users will quickly learn how to automate reports and design applications. Brilliant Excel VBA & Macros explains the shortcomings of the macro recorder, but also covers how to take the recorded code and turn it into something really useful. Once the user has mastered the macro recorder, the book explains how to understand the object- oriented Visual Basic for Applications Language.

Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.

Bill Jelen "Mr. Excel" is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen spent twelve years in the trenches, working as a financial analyst for finance, marketing, accounting and operations departments of a $500 million public company. Tracy Syrstad works as an Excel and Access Consultant. As part of the Mr.Excel.com Consulting team, she has helped develop VBA solutions for clients around the world. She remembers the painful trek up the VBA learning curve while developing applications for co-workers at a former job. She is co-editor of Holy Macro!, it's "600 Excel VBA Examples CD" and editor of Dreamboat On Word.

Introduction

Unleash the Power of Excel with VBA
This Sounds Like BASIC, So Why Doesn't It Look Familiar
Referring to Ranges
User-Defined Functions
Looping and Flow Control
R1C1-Style Formulas
What's New in Excel 2007 and What's Changed
Create and Manipulate Names in VBA
Event Programming
Userforms - An Introduction
Creating Charts
Data Mining with Advanced Filter
Using VBA to Create Pivot Tables
Excel Power
Data Visualizations and Conditional Formatting
Reading from and Writing to the Web
XML in Excel 2007
Automating Word
Arrays
Text File Processing
Using Access as a Back End to Enhance Multi-User Access to Data
Creating Classes, Records, and Collections
Advanced Userform Techniques
Windows Application Programming Interface (API)
Handling Errors
Customising the Ribbon to Run Macros
Creating Add-Ins

Index

Erscheint lt. Verlag	14.12.2007
Sprache	englisch
Maße	191 x 229 mm
Gewicht	1120 g
Themenwelt	Informatik ► Office Programme ► Excel
ISBN-10	0-273-71405-8 / 0273714058
ISBN-13	978-0-273-71405-7 / 9780273714057
Zustand	Neuware