更多好资料可以关注我哦
Book Details
- Title: 101 Ready-To-Use Excel Macros
- Author: Michael Alexander
- Length: 336 pages
- Edition: 1
- Language: English
- Publisher: Wiley
- Publication Date: 2012-06-13
- ISBN-10: 1118281217
- ISBN-13: 9781118281215
Editorial Reviews
Save time and be more productive with thishelpful guide to Excel macros!
While most books about Excel macros offeronly minor examples, usually aimed at illustrating a particular topic, thisinvaluable resource provides you with the tools needed to efficiently andeffectively program Excel macros immediately. Step-by-step instructions showyou how to create VBA macros and explain how to customize your applications tolook and work exactly as you want them to. By the end of the book, you willunderstand how each featured macro works, be able to reuse the macros includedin the book and online, and modify the macro for personal use.
Shows you how to solve common problems withthe featured macros, even if you lack extensive programming knowledge
Outlines a problem that needs to be solvedand provides the actual Excel macro, as well as the downloadable code, to solvethe problem
Provides an explanation of how each macroworks and where to use the macro
With 101 Ready-to-Use Excel Macros,Microsoft MVP Michael Alexander helps you save time, automate tasks, andultimately be more productive.
Table of Contents
- PART I: Getting Started with Excel Macros
- PART II: Working with Workbooks
- Macro 1: Creating a New Workbook fromScratch
- Macro 2: Saving a Workbook When aParticular Cell Is Changed
- Macro 3: Saving a Workbook Before Closing
- Macro 4: Protect a Worksheet on WorkbookClose
- Macro 5: Unprotect a Worksheet on WorkbookOpen
- Macro 6: Open a Workbook to a Specific Tab
- Macro 7: Opening a Specific WorkbookDefined by the User
- Macro 8: Determine Whether a Workbook IsAlready Open
- Macro 9: Determine Whether a WorkbookExists in a Directory
- Macro 10: Refresh All Data Connections inWorkbook on Open
- Macro 11: Close All Workbooks at Once
- Macro 12: Open All Workbooks in a Directory
- Macro 13: Print All Workbooks in aDirectory
- Macro 14: Preventing the Workbook fromClosing Until a Cell Is Populated
- Macro 15: Create a Backup of a CurrentWorkbook with Today’s Date
- PART III: Automating Worksheet Tasks withMacros
- Macro 16: Add and Name a New Worksheet
- Macro 17: Delete All but the ActiveWorksheet
- Macro 18: Hide All but the Active Worksheet
- Macro 19: Unhide All Worksheets in aWorkbook
- Macro 20: Moving Worksheets Around
- Macro 21: Sort Worksheets by Name
- Macro 22: Group Worksheets by Color
- Macro 23: Copy a Worksheet to a NewWorkbook
- Macro 24: Create a New Workbook for EachWorksheet
- Macro 25: Print Specified Worksheets
- Macro 26: Protect All Worksheets
- Macro 27: Unprotect All Worksheets
- Macro 28: Create a Table of Contents forYour Worksheets
- Macro 29: Zooming In and Out of a Worksheetwith Double-Click
- Macro 30: Highlight the Active Row andColumn
- PART IV: Selecting and Modifying Ranges
- Macro 31: Selecting and Formatting a Range
- Macro 32: Creating and Selecting NamedRanges
- Macro 33: Enumerating Through a Range ofCells
- Macro 34: Select and Format All NamedRanges
- Macro 35: Inserting Blank Rows in a Range
- Macro 36: Unhide All Rows and Columns
- Macro 37: Deleting Blank Rows
- Macro 38: Deleting Blank Columns
- Macro 39: Select and Format All Formulas ina Workbook
- Macro 40: Find and Select the First BlankRow or Column
- Macro 41: Apply Alternate Color Banding
- Macro 42: Sort a Range on Double-Click
- Macro 43: Limit Range Movement to aParticular Area
- Macro 44: Dynamically Set the Print Area ofa Worksheet
- PART V: Working with Data
- Macro 45: Copy and Paste a Range
- Macro 46: Convert All Formulas in a Rangeto Values
- Macro 47: Perform the Text to ColumnsCommand on All Columns
- Macro 48: Convert Trailing Minus Signs
- Macro 49: Trim Spaces from All Cells in aRange
- Macro 50: Truncate ZIP Codes to the LeftFive
- Macro 51: Padding Cells with Zeros
- Macro 52: Replace Blanks Cells with a Value
- Macro 53: Append Text to the Left or Rightof Your Cells
- Macro 54: Create a Super Data Cleanup Macro
- Macro 55: Clean Up Non-Printing Characters
- Macro 56: Highlight Duplicates in a Rangeof Data
- Macro 57: Hide All Rows but ThoseContaining Duplicate Data
- Macro 58: Selectively Hide AutoFilterDrop-down Arrows
- Macro 59: Copy Filtered Rows to a NewWorkbook
- Macro 60: Create a New Sheet for Each Itemin an AutoFilter
- Macro 61: Show Filtered Columns in theStatus Bar
- PART VI: Working with PivotTables
- Macro 62: Create a Backwards-CompatiblePivotTable
- Macro 63: Refresh All PivotTables Workbook
- Macro 64: Create a Pivot Table InventorySummary
- Macro 65: Make All PivotTables Use the SamePivot Cache
- Macro 66: Hide All Subtotals in aPivotTable
- Macro 67: Adjust All Pivot Data FieldTitles
- Macro 68: Set All Data Items to Sum
- Macro 69: Apply Number Formatting for AllData Items
- Macro 70: Sort All Fields in AlphabeticalOrder
- Macro 71: Apply Custom Sort to Data Items
- Macro 72: Apply PivotTable Restrictions
- Macro 73: Apply Pivot Field Restrictions
- Macro 74: Automatically Delete Pivot TableDrill-Down Sheets
- Macro 75: Print Pivot Table for Each ReportFilter Item
- Macro 76: Create New Workbook for EachReport Filter Item
- Macro 77: Transpose Entire Data Range witha PivotTable
- PART VII: Manipulating Charts with Macros
- Macro 78: Resize All Charts on a Worksheet
- Macro 79: Align a Chart to a Specific Range
- Macro 80: Create a Set of DisconnectedCharts
- Macro 81: Print All Charts on a Worksheet
- Macro 82: Label First and Last Chart Points
- Macro 83: Color Chart Series to MatchSource Cell Colors
- Macro 84: Color Chart Data Points to MatchSource Cell Colors
- PART VIII: E-Mailing from Excel
- Macro 85: Mailing the Active Workbook as anAttachment
- Macro 86: Mailing a Specific Range asAttachment
- Macro 87: Mailing a Single Sheet as anAttachment
- Macro 88: Send Mail with a Link to OurWorkbook
- Macro 89: Mailing All E-Mail Addresses inOur Contact List
- Macro 90: Saving All Attachments to aFolder
- Macro 91: Saving Certain Attachments to aFolder
- PART IX: Integrating Excel and Other OfficeApplications
- Macro 92: Running an Access Query fromExcel
- Macro 93: Running an Access Macro fromExcel
- Macro 94: Opening an Access Report fromExcel
- Macro 95: Opening an Access Form from Excel
- Macro 96: Compacting an Access Databasefrom Excel
- Macro 97: Sending Excel Data to a WordDocument
- Macro 98: Simulating Mail Merge with a WordDocument
- Macro 99: Sending Excel Data to aPowerPoint Presentation
- Macro 100: Sending All Excel Charts to aPowerPoint Presentation
- Macro 101: Convert a Workbook into aPowerPoint Presentation
本帖隐藏的内容