Microsoft® Office Excel® 2007 Visual Basic® for Applications Step by Step
Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Create macros to automate repetitive tasksAutomatical...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Colección: | Step by Step
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627091806719 |
Tabla de Contenidos:
- Cover; Copyright Page; Contents; 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 Offi ce 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; Chapter 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 CurrencyRun 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 CommandsConvert 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; Chapter 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 RunTask 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 AppendData Macro; Record a Relative Movement; Choose Whether to Save Changes While Closing a File; Task Five: Deleting the Worksheet; Create a Macro to Delete the Active Worksheet; Make the Macro Operate Quietly; Assembling the Pieces; Record a Macro That Runs Other Macros; Simplify the Subroutine Statements; Key Points; Chapter 3: Explore Workbooks and Worksheets
- What Is an Object?Objects Come in Collections; Objects Have Properties; Objects Have Methods; Methods Can Change Properties; Properties Can Involve Actions; Understanding Workbooks; Add a New Workbook; Sidebar: Dockable Views; Count the Workbooks; Close the Workbooks; Refer to a Single Workbook; Refer to a Workbook by Name; Refer to a Workbook by Pointing; Change a Workbook Property Value; Understanding Worksheets; Add a New Worksheet; Rename and Delete a Worksheet; Look at the Return Value of the Delete Method; Look at the Result of the Add Method; Copy a Worksheet
- Manipulate Multiple Worksheets
