最 低 价：￥243.90
| 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 |
内容加载中，请稍后...
商品评论（0条）