【图书简介】 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.-读书网|DuShu.com
【本书目录】 About the Author Features and Conventions of This Book Using 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 Files Getting Help Getting Help with This Book and Its Companion CD More Information 1 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 Points 2 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 Worksheets 4 Explore Range Objects 5 Explore Data Objects 6 Explore Graphical Objects 7 Control Visual Basic 8 Extend Excel and Visual Basic 9 Launch Macros with Events 10 Use Dialog Box Controls on a Worksheet 11 Create a Custom Form Appendix: A Complete Enterprise Information System Index
【图书简介】
【购买本书】
