151 The Most Popular Macros for Word 2023 and Word 365 by Klemens Nguyen
English | June 8, 2023 | ISBN: N/A | ASIN: B0C7LGMWXX | 85 pages | EPUB | 0.78 Mb
English | June 8, 2023 | ISBN: N/A | ASIN: B0C7LGMWXX | 85 pages | EPUB | 0.78 Mb
In this book you can find:
- 151 ready to use macros,
- VBA listings,
- no theory - only practical examples,
- the most frequently searched topics about ms Word macros.
Chapter 1. Inserting Content
Insert Placeholder Text, Current Date, Signature, Header or Footer, Bulleted List, Numbered List, Text from Clipboard, File Content, Page Number, Placeholder Image, Image from File, Clipboard Image, Placeholder Image, Linked Image, AutoFit Image, Captioned Image, Cropped Image, Resized Image, Table with Specific Rows and Columns, Table from Excel Spreadsheet, Quick Table, Table with AutoFit to Contents, Table with Borders, Table with Shading
Chapter 2. Formatting and Styling
Change: Font Size, Font Colour, Font Style, Font Name. A
Apply Underline, Clear Formatting, Highlight Text, Change Case, Align Paragraphs, Change Line Spacing, Indent Paragraphs, Apply Bullets or Numbering, Change Paragraph Spacing Before and After, Set First Line Indentation
Change Paragraph Shading, Clear Formatting, Apply Heading Style 1, Apply Heading Style 2, Apply Heading Style 3.
Modify: Heading Style Font Size, Heading Style Font Colour, Heading Style Bold, Heading Style Alignment, Heading Style Numbering.
Change: Page Orientation, Change Paper Size, Margins, Page Width and Height, Header and Footer, Page Numbering Format.
Chapter 3. Automating Repetitive Tasks
Find and Replace: Text, Formatting, with Wildcards, with Case Sensitivity, Whole Words Only, in Batch.
Apply: Font Style to Selected Text, Heading Style to Multiple Paragraphs, Highlight Colour to Selected Text, Apply Borders to Table Cells, Macro to All Open Documents.
Change: Paragraph Spacing for Selected Text, Page Colour
Loop Through All Documents in a Folder
Perform Document Conversion
Chapter 4. Navigating and Selecting
Go to: Next Heading, Previous Heading, Next Page, Previous Page, Beginning of Document, End of Document.
Select: Current Line, Current Paragraph, Specific Word, Text Between Two Bookmarks.
Move Cursor to: Beginning of Document, End of Document, Start of Line, End of Line, Start of Paragraph, End of Paragraph.
Chapter 5. Managing Document Properties
Get, Set or Remove Document Property Value
Set or Update Document: Title, Author, Keywords, Subject, Comments, Custom Property Value.
Remove Custom Property
Set or Update Author: Name, Initials, Email Address, Company.
Chapter 6. Generating Reports or Summaries
Generate: Word Count Report, Character Count Report, Paragraph Count Report, Document Statistics, Summary of Document Content.
Analyse Document Structure
Chapter 7. Interacting with External Data or Applications
Retrieve Data from Database
Update Data in Database
Open External Application
Send Data to External Application
Get Data from External Application
Import Data from: Excel, CSV (Comma-Separated Values) File, Text File.
Export Document as: PDF, Plain Text, HTML.
Sort Table Data
Remove Duplicates in Table Column
Split Text into Multiple Columns
Find and Replace Text
Concatenate Table Cells
Chapter 8. Customizing User Interface
Customize: Ribbon, Quick Access Toolbar, Keyboard Shortcuts.
Create Custom Button on Ribbon
Chapter 9. Collaboration and Reviewing
Track Changes: Accept All, Reject All, Toggle, Accept Selected, Reject Selected.
Insert Comment with: Author Name, Custom Text ,Timestamp.
Chapter 10. Document Automation and Workflows
Automated Document Generation. Document Assembly from Multiple Sources, Data Extraction and Analysis, Export Word Document to Excel, Merge Word Documents with PowerPoint Presentations, The most popular Macros for interacting with external systems, Retrieve Data from a Web Service, Perform Database Query and Update.