OFFICE EXCEL 2010 VBA

所需积分/C币:24 2014-08-18 10:29:26 11.74MB PDF

office excel 2010 vba 官方手册,英文原版,高清可编辑
E兴oo3sssvom=o3Eo=oG Mastering VBA for microsoft office 2010 Richard mansfield WILEY Wiley Publishing, Inc ffirs indd i 23/20103:55:53PM Acquisitions Editor: Agatha Kim Development Editor: Denise Lincoln Technical Editor: Russ mullen Rachel gigli Copy Editor: Judy Flyr Editorial Manager: Pete Gaughan Production Manager: Tim Tate Vice President and Executive Group Publisher: Richard Wadley Vice president and Publisher: Neil edde Book Designers: Maureen Forys and Judy fung Proofreader: Publication Services, Ino Project Coordinator, Cover: Lynsey Stanford Cover Designer: Ryan Sneed Cover Image: C Pete Gardner/Digital Vision/Getty Images Copyright o 2010 by Wiley Publishing, Inc, Indianapolis, Indiana Published simultaneously in Canada ISBN:978-0-470-63400-4 No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechan ical, 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 pay ment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA01923, (978)750-8400, fax(978)646-8600 Requests to the Publisher forper mission should be addressed to the Permissions Department, John wiley sons, Inc, 111 River Street, Hoboken, NJ 07030, (201)748-6011 fax(201)748-6008,oronlineathttp://www.wiley.com/go/permissions Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a Particular purpose. No warranty may be created or extended by sales or promotional matcrials. The advice and strategics contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is notengaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Web site may provide or recommendations it may make. Further, readers should be aware that Internet Web sites listed in this work may have changed or disappeared between when this work was written and when it is read For general in formation on our other products and services or to obtain technical support, please contact our Customer Care Department within the U. S at(877)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 Library of Congress Cataloging-in-Publication Data Mansfield, Richard, 1945- Mastering VBA for Office 2010/ Richard Mansfield -Ist ed D cm ISBN978-0-470-63400-4(pbk) ISBN978-0-47092263-7(ebk) ISBN978-0-470-92265-1(ebk) ISBN978-0-47092264-4(ebk) 1. Microsoft Visual Basic for applications. 2. Microsoft Office. L. Title QA7673M53M362010 005.2768-dc22 2010021585 TRADEMARKS: Wiley, the Wiley logo, and the Sybex 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. Microsoft is a registered trademark of Microsoft Corporation. All other trademarks are the property of their respective owners. Wiley Publishing, InC is not associated withany roduct or vendor mentioned in this book 10987654321 ffirs indd ii 23/20103:55:55PM Dear Reader Thank you for choosing Mastering VBA for Microsoft Office 2010. This book is part of a family of premium-quality Sybex books, all of which are written by outstanding authors who combine practical experience with a gift for teaching Sybex was founded in 1976. More than 30 years later, were still committed to producing consis- tently exceptional books. With each of our titles, were working hard to set a new standard for the industry. From the paper we print on, to the authors we work with, our goal is to bring you the best books available I hope you see all that reflected in these pages. Id be very interested to hear your comments and get your feedback on how were doing. Feel free to let me know what you think about this or anyotherSybexbookbysendingmeanemailatnedde@wiley.com.Ifyouthinkyou'vefound atechnicalerrorinthisbookpleasevisithttp://sybex.custhelp.comCustomerfeedbackis critical to our efforts at Sybex Be Neil edde Vice president and publisher Sybex, an Imprint of Wiley ffirs indd iii 23/20103:55:55PM I dedicate this book to my good friend Cliff Way ffirsindd iv 23/20103:55:55PM Acknowledgments Id like to thank all the good people at Sybex who contributed to this book, in particular Agatha Kim, whose encouragement made this book possible in the first place and whose thoughtful guidance was helpful during the writing process. I am also indebted to Denise Lincoln, the development editor, whose many valuable suggestions contributed to this book's readability and cohesion. My gratitude also goes to Judy Flynn, the copy editor, who via a very close, line-by- line read, improved this book in many ways; she is truly an exceptional copy editor. The techni cal editor, Russ Mullen, checked the book for accuracy and ensured that all the code examples work without any errors. Finally, thanks to capable Rachel gigliotti, production editor, the book went smoothly through its final stages -author review and production ffirsindd v 23/20103:55:55PM About the author Mastering VBA for Microsoft Ofice 2010 is Richard Mansfield's 45th book. His recent titles include Visual Basic. NET Power Tools(Sybex, 2003), Office Application Development All-in-One Desk Reference for dummies(wiley, 2004), and Programming: A Beginner's Guide(mcgraw-Hill, 2009) Overall, his books have sold more than 500,000 copies worldwide and have been translated into 121 ffirs indd vi 23/20103:55:55PM Contents at a glance Part 1. Recording Macros and Getting Started with VBa Chapter 1 Recording and Running Macros in the Office Applicat P hapter 2. Getting Started with the Visual Basic Edi Chapter 3. Editing Recorded Macros 65 Chapter 4. Creating Code from Scratch in the Visual Basic Editor Part 2. Learning How to Work with VBa 105 Chapter 5. Understanding the Essentials of VBA Syntax 107 Chapter 6. Working with Variables, Constants, and Enumerations .123 Chapter 7. Using Array variables 145 hapter 8. Finding the Objects, Methods, and Properties You Need Part 3. Making Decisions and Using Loops and functions 191 Chapter 9. Using Built-in Functions 193 Chapter 10 Creating Your Own Functions 227 Chapter 11 Making Decisions in Your Code 245 hapter 12. Using Loops to Repeat Actic 65 Part 4. Using Message Boxes, Input Boxes, and dialog boxes........ 293 Chapter 13 Getting Cser Input with Message Boxes and Input Boxes Chapter 14 Creating Simple Custom Dialog Boxes ......315 Chapter 15 Creating Complex Dialog Boxes 381 ffirs indd vii 23/20103:55:55PM VIl CONTENTS ATAGLANCE Part 5 Creating Effective Code.................... 429 Chapter 16. Building modular Code and Using Classes Chapter 17. Debugging Your Code and Handling Errors 457 Chapter 18 Building Well-Behaved Code .487 Chapter 19. Securing Your Code with VBAs Security Features Part 6. Programming the office Applications 525 Chapter 20 Understanding the Word Object Model and Key Objects 527 Chapter 21. Working with Widely Used Objects in Word 559 Chapter22· Understanding the Excel Object Model and Key objects∴…….591 Chapter 23. Working with Widely Used Objects in Excel 617 Chapter 24 Understanding the powerPoint Object Model and Key objects 631 Chapter 25. Working with Shapes and Running Slide Shows 653 Chapter 26. Understanding the Outlook Object Model and Key objects..... 673 Chapter 27 Working with Events in Outlook 693 Chapter28· Understanding the Access Object Model and Key objects.………713 Chapter 29. Manipulating the data in an Access Database via VBA 735 Chapter 30. Accessing One Application from Another Application 755 Chapter 31 Programming the Office 2010 Ribbon dix· The Bottom li Index 855 ffirsindd vii: 23/20103:55:55PM

...展开详情
试读 127P OFFICE EXCEL 2010 VBA
img
Jim_TW

关注 私信 TA的资源

上传资源赚积分,得勋章
    最新推荐
    OFFICE EXCEL 2010 VBA 24积分/C币 立即下载
    1/127
    OFFICE EXCEL 2010 VBA第1页
    OFFICE EXCEL 2010 VBA第2页
    OFFICE EXCEL 2010 VBA第3页
    OFFICE EXCEL 2010 VBA第4页
    OFFICE EXCEL 2010 VBA第5页
    OFFICE EXCEL 2010 VBA第6页
    OFFICE EXCEL 2010 VBA第7页
    OFFICE EXCEL 2010 VBA第8页
    OFFICE EXCEL 2010 VBA第9页
    OFFICE EXCEL 2010 VBA第10页
    OFFICE EXCEL 2010 VBA第11页
    OFFICE EXCEL 2010 VBA第12页
    OFFICE EXCEL 2010 VBA第13页
    OFFICE EXCEL 2010 VBA第14页
    OFFICE EXCEL 2010 VBA第15页
    OFFICE EXCEL 2010 VBA第16页
    OFFICE EXCEL 2010 VBA第17页
    OFFICE EXCEL 2010 VBA第18页
    OFFICE EXCEL 2010 VBA第19页
    OFFICE EXCEL 2010 VBA第20页

    试读已结束,剩余107页未读...

    24积分/C币 立即下载 >