Vba and macros en excel

From the Library of Wow! eBook

C o n t e n t s
Introduction

a t

a

G l a n c e

1 Unleash the Power of Excel with VBA 2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar? 3 Referring to Ranges 4 User-Defined Functions

MrExcel
LIBRARY

5 Looping and Flow Control 6 R1C1-Style Formulas 7 What Is New in Excel 2010 and What Has Changed

VBA and Macros: Microsoft®Excel® 2010

8 Create and Manipulate Names in VBA 9 Event Programming 10 Userforms—An Introduction 11 Creating Charts 12 Data Mining with Advanced Filter 13 Using VBA to Create Pivot Tables 14 Excel Power 15 Data Visualizations and Conditional Formatting 16 Reading from and Writing to the Web 17 Dashboarding with Sparklines in Excel 2010 18 Automating Word 19 Arrays 20 Text File Processing 21Using Access as a Back End to Enhance Multiuser Access to Data

Bill Jelen Tracy Syrstad

22 Creating Classes, Records, and Collections 23 Advanced Userform Techniques 24 Windows API 25 Handling Errors 26 Customizing the Ribbon to Run Macros 27 Creating Add-Ins Index

Pearson Education 800 E. 96th Street Indianapolis, Indiana 46240

From the Library of Wow! eBook

VBA and Macros:Microsoft ® Excel® 2010
Copyright © 2010 by Que Publishing All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Althoughevery precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein. ISBN-13: 978-0-7897-4314-5 ISBN-10: 0-7897-4314-0 Library of Congress Cataloging-in-Publication Data: Jelen, Bill. VBA and macros : Microsoft Excel 2010 /Bill Jelen, Tracy Syrstad. p. cm. Includes index. ISBN-13: 978-0-7897-4314-5 ISBN-10: 0-7897-4314-0 1. Microsoft Excel (Computer file) 2. Microsoft Visual Basic for applications. 3. Business—Computer programs. 4. Electronic spreadsheets. I. Syrstad, Tracy. II. Title. HF5548.4.M523J46 2010 005.54—dc22 2010018831 Printed in the United States of America First Printing: June 2010 Trademarks Allterms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Que Publishing cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark. Microsoft and Excel are a registered trademarks of Microsoft Corporation. Warning and Disclaimer Everyeffort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an “as is” basis. The authors and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book. Bulk Sales Que Publishing offersexcellent discounts on this book when ordered in quantity for bulk purchases or special sales. For more information, please contact U.S. Corporate and Government Sales 1-800-382-3419 corpsales@pearsontechgroup.com For sales outside the United States, please contact International Sales international@pearson.com

Associate Publisher
Greg Wiegand

Acquisitions Editor
Loretta Yates

DevelopmentEditor
Sondra Scott

Managing Editor
Sandra Schroeder

Senior Project Editor
Tonya Simpson

Copy Editor
Keith Kline

Indexer
Erika Millen

Proofreader
Language Logistics

Technical Editor
Bob Umlas

Publishing Coordinator
Cindy Teeters

Book Designer
Anne Jones

Compositor
Bronkella Publishing

From the Library of Wow! eBook

Contents
Introduction ....