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

2007-5  

Microsoft Press  

Reed Jacobson  

354  

无  

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.

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

无

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