DeMarco - Pro Excel 2007 VBA (Apress, 2008).pdf

(8776 KB) Pobierz
Layout 1
The eXperT’s Voice ® in eXcel VBa
Excel 2007
VBA
Learn to build high-performance
applications in Excel 2007 using VBA
Jim DeMarco
Pro
208841753.045.png 208841753.056.png 208841753.067.png 208841753.077.png 208841753.001.png 208841753.002.png 208841753.003.png 208841753.004.png 208841753.005.png 208841753.006.png 208841753.007.png 208841753.008.png 208841753.009.png 208841753.010.png 208841753.011.png 208841753.012.png 208841753.013.png 208841753.014.png 208841753.015.png 208841753.016.png 208841753.017.png 208841753.018.png 208841753.019.png 208841753.020.png 208841753.021.png 208841753.022.png 208841753.023.png 208841753.024.png 208841753.025.png 208841753.026.png 208841753.027.png
 
208841753.028.png
 
208841753.029.png
 
208841753.030.png
 
208841753.031.png
 
208841753.032.png 208841753.033.png 208841753.034.png 208841753.035.png 208841753.036.png 208841753.037.png 208841753.038.png 208841753.039.png 208841753.040.png 208841753.041.png 208841753.042.png
 
208841753.043.png 208841753.044.png 208841753.046.png 208841753.047.png 208841753.048.png 208841753.049.png 208841753.050.png 208841753.051.png 208841753.052.png 208841753.053.png 208841753.054.png 208841753.055.png 208841753.057.png 208841753.058.png 208841753.059.png 208841753.060.png 208841753.061.png 208841753.062.png 208841753.063.png 208841753.064.png 208841753.065.png 208841753.066.png 208841753.068.png 208841753.069.png 208841753.070.png 208841753.071.png
 
Pro Excel 2007 VBA
Jim DeMarco
208841753.072.png 208841753.073.png 208841753.074.png
Pro Excel 2007 VBA
Copyright © 2008 by Jim DeMarco
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means,
electronic or mechanical, including photocopying, recording, or by any information storage or retrieval
system, without the prior written permission of the copyright owner and the publisher.
ISBN-13 (pbk): 978-1-59059-957-0
ISBN-10 (pbk): 1-59059-957-8
ISBN-13 (electronic): 978-1-4302-0580-7
ISBN-10 (electronic): 1-4302-0580-6
Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1
Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence
of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark
owner, with no intention of infringement of the trademark.
Lead Editor: Tony Campbell
Technical Reviewer: Mark Etwaru
Editorial Board: Clay Andres, Steve Anglin, Ewan Buckingham, Tony Campbell, Gary Cornell,
Jonathan Gennick, Kevin Goff, Matthew Moodie, Joseph Ottinger, Jeffrey Pepper, Frank Pohlmann,
Ben Renow-Clarke, Dominic Shakeshaft, Matt Wade, Tom Welsh
Project Manager: Kylie Johnston
Copy Editor: Damon Larson
Associate Production Director: Kari Brooks-Copony
Production Editor: Liz Berry
Compositor: Linda Weidemann, Wolf Creek Press
Proofreaders: Linda Seifert, April Eddy
Indexer: Carol Burbo
Artist: April Milne
Cover Designer: Kurt Krames
Manufacturing Director: Tom Debolski
Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor,
New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail orders- ny@springer-sbm.com , or
For information on translations, please contact Apress directly at 2855 Telegraph Avenue, Suite 600,
Berkeley, CA 94705. Phone 510-549-5930, fax 510-549-5939, e-mail info@apress.com , or visit
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use.
eBook versions and licenses are also available for most titles. For more information, reference our
Special Bulk Sales–eBook Licensing web page at http://www.apress.com/info/bulksales .
The information in this book is distributed on an “as is” basis, without warranty. Although every pre-
caution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any
liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly
or indirectly by the information contained in this work.
The source code for this book is available to readers at http://www.apress.com .
208841753.075.png
This book is dedicated to my beautiful wife, Marlene, who
continually challenges me to excel (no pun intended). I would also
like to dedicate it to my two very talented teens, Jimmy and Melanie,
who never fail to impress us with their creative powers.
208841753.076.png
Zgłoś jeśli naruszono regulamin