Excel 2003 Power Programming with VBA.pdf

(82946 KB) Pobierz
E
XCEL
2003
P
P
Microsoft
®
Office
OWER
ROGRAMMING
WITH
VBA
“Mr. Spreadsheet,” author of
Excel Charts
and
Excel Formulas
John Walkenbach
Includes Power Utility Pak
trial version and more on
CD-ROM
Excel 2003 Power
Programming
with VBA
John Walkenbach
Excel 2003 Power Programming with VBA
Published by
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com
Copyright © 2004 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
Library of Congress Catalog Card Number: 2003105685
ISBN: 0-7645-4072-6
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
1B/SZ/RS/QT/IN
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by
any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under
Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of
the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance
Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher
for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd.,
Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4447, e-mail:
permcoordinator@wiley.com
.
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: WHILE THE PUBLISHER AND AUTHOR HAVE
USED THEIR BEST EFFORTS IN PREPARING THIS BOOK, THEY MAKE NO REPRESENTATIONS OR
WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS
BOOK AND SPECIFICALLY DISCLAIM ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR
FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES
REPRESENTATIVES OR WRITTEN SALES MATERIALS. THE ADVICE AND STRATEGIES CONTAINED
HEREIN MAY NOT BE SUITABLE FOR YOUR SITUATION. YOU SHOULD CONSULT WITH A
PROFESSIONAL WHERE APPROPRIATE. NEITHER THE PUBLISHER NOR AUTHOR SHALL BE LIABLE
FOR ANY LOSS OF PROFIT OR ANY OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT LIMITED
TO SPECIAL, INCIDENTAL, CONSEQUENTIAL, OR OTHER DAMAGES.
For general information on our other products and services or to obtain technical support, please contact
our Customer Care Department within the U.S. at (800) 762-2974, outside the U.S. at (317) 572-3993 or fax
(317) 572-4002.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not
be available in electronic books.
Trademarks:
Wiley and the Wiley logo are trademarks or registered trademarks of John Wiley & Sons, Inc.
and/or its affiliates, in the United States and other countries, and may not be used without written permission.
All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not associated with
any product or vendor mentioned in this book.
is a trademark of Wiley Publishing, Inc.
Credits
SENIOR ACQUISITIONS EDITOR
Greg Croy
PROJECT EDITOR
Linda Morris
TECHNICAL EDITOR
Bill Manville
SENIOR COPY EDITOR
Teresa Artman
EDITORIAL MANAGER
Leah Cameron
VICE PRESIDENT & EXECUTIVE
GROUP PUBLISHER
Richard Swadley
VICE PRESIDENT AND PUBLISHER
Andy Cummings
EDITORIAL DIRECTOR
Mary C. Corder
PROJECT COORDINATOR
Ryan Steffen
GRAPHICS AND PRODUCTION
SPECIALISTS
Lauren Goddard
Michael Kruzil
Lynsey Osborn
Julie Trippetti
Melanie Wolven
PROOFREADERS
Carl William Pierce, TECHBOOKS
Production Services
SENIOR PERMISSIONS EDITOR
Carmen Krikorian
MEDIA DEVELOPMENT SPECIALIST
Travis Silvers
INDEXER
TECHBOOKS Production Services
About the Author
John Walkenbach
is a leading authority on spreadsheet software and is principal of
JWalk and Associates Inc., a small San Diego-based consulting firm that specializes
in spreadsheet application development. John is the author of more than 30 spread-
sheet books and has written more than 300 articles and reviews for a variety of
publications, including
PC World, InfoWorld, Windows,
and
PC/Computing.
He also
maintains
The Spreadsheet Page,
a popular Internet Web site (
www.j-walk.com/
ss
), and is the developer of Power Utility Pak, an award-winning add-in for
Microsoft Excel. John graduated from the University of Missouri and earned a mas-
ters degree and a Ph.D. from the University of Montana.
In addition to computers and spreadsheet software, John’s other interests include
guitar, music, novels, digital photography, and puttering around in the garden.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin