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格式下载