Microsoft Office Excel 2007 Visual Basic 应用进阶指南

书籍目录

About the AuthorFeatures and Conventions of This BookUsing the Book's CD  What's on the CD?  Minimum System Requirements    Step-by-Step Exercises    2007 Microsoft Office System  Installing the Practice Files  Using the Practice Files  Removing and Uninstalling the Practice FilesGetting Help  Getting Help with This Book and Its Companion CD   More Information1 Make a Macro Do Simple Tasks  What's the Difference Between VBA and a Macro?    Sidebar: VBA and the .NET Framework  Creating a Simple Macro　　Format Currency by Using a Built-In Tool　　Record a Macro to Format Currency　　Run the Macro　　Assign a Shortcut Key to the Macro　　Look at the Macro　　Save the Macro Workbook　Changing Multiple Properties at Once    Create Sidebar Headings with a Command    Record a Macro to Merge Cells Vertically    Eliminate Unnecessary Lines from the Macro　Manipulating Recorded Properties    Record a Macro to Remove Window Elements    Run the Macro from the Visual Basic Editor    Use a Macro to Toggle the Value of a Property    Eliminate Repeated Objects in a Recorded Macro    Run a Macro from the Quick Access Toolbar　Recording Methods in a Macro    Convert a Formula to a Value by Using Menu Commands    Convert a Formula to a Value by Using a Macro    Make a Long Statement More Readable　Trusting Macro-Enabled Workbooks    Designate a Trusted Location for Macros    Designate a Trusted Publisher for Macros　Key Points2 Make a Macro Do Complex Tasks　Task One: Opening the Report File    Open a Text File    Watch a Macro Run by Stepping Through It    Select a File While Running a Macro　Task Two: Filling In Missing Labels    Select Only the Blank Cells    Fill the Selection with Values    Record Filling In the Missing Values    Watch the FillLabels Macro Run　Task Three: Adding a Column of Dates    Add a Constant Date    Step Through the Macro    Prompt for the Date　Task Four: Appending to the Database    Append Data to a Master List    Step Through the Append Data Macro　……3 Explore Workbooks and Worksheets4 Explore Range Objects5 Explore Data Objects6 Explore Graphical Objects7 Control Visual Basic8 Extend Excel and Visual Basic9 Launch Macros with Events10 Use Dialog Box Controls on a Worksheet11 Create a Custom FormAppendix: A Complete Enterprise Information SystemIndex

作者简介

Experience learning made easy, and quickly teach yourselfMicrosoft Office Excel 2007 Visual Basic for Applications (VBA)--one stepat a time! Work at your own pace through the easy numbered steps andpractice files on CD, and master the fundamentals for using VBA to createcustom software solutions and automating tasks in Excel 2007--no developerexperience required! You'll learn how to automate spreadsheets, write yourown functions and procedures, and customize menus and toolbars. You'lldiscover Excel Objects, including workbooks, range objects, graphics, andPivotTables-. Plus, you'll learn how to chart data from databases andother information sources. With STEP BY STEP, you can take just the lessonsyou need or work from cover to cover. Either way, you drive theinstruction--building and practicing the skills you need, just when youneed them! Includes a companion CD with hands-on practice files.

 Microsoft Office Excel 2007 Visual Basic 应用进阶指南下载