MSK Institute • Shikohabad
Loading Page Content...
Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...
Connecting serverPlease wait...
💻 Practical Labs🚀 Free Demo📜 Verified Certificates
Practical Macro Examples0%
Practical Macro Examples
Beginner12 min read•Updated: Jul 11, 2026
Practical Macro Examples
Practical Macro Recipes & VBA Automation
Behind every recorded macro in Microsoft Word is Visual Basic for Applications (VBA) code. Pressing Alt + F11 opens the VBA Integrated Development Environment (IDE), allowing you to inspect, fine-tune, and supercharge your macros.
Click to ZoomRecipe 1: The "Clean Pasted Web Text" Macro
When text is pasted from websites, it often contains unwanted formatting, hyperlinks, double spaces, and grey background fills. This macro strips everything and standardizes the text in one click:
Sub CleanPastedText()
' Strips character and paragraph formatting
Selection.ClearFormatting
Selection.Font.Name = "Calibri"
Selection.Font.Size = 11
Selection.Font.ColorIndex = wdBlack
Selection.ParagraphFormat.LineSpacingRule = wdLineSpaceSingle
Selection.ParagraphFormat.SpaceAfter = 6
Selection.ParagraphFormat.Alignment = wdAlignParagraphJustify
End Sub
Recipe 2: The "Corporate Footer Stamp" Macro
Automatically injects the standard corporate footer with file path, date, and page numbers across all sections:
Sub AddCorporateFooter()
Dim sec As Section
For Each sec In ActiveDocument.Sections
With sec.Footers(wdHeaderFooterPrimary).Range
.Text = "Confidential - MSK Institute | Printed on: " & Format(Date, "dd-mmm-yyyy")
.Font.Name = "Segoe UI"
.Font.Size = 9
.Font.ColorIndex = wdGray50
.ParagraphFormat.Alignment = wdAlignParagraphCenter
End With
Next sec
End Sub
Recipe 3: The 1-Click "Export Clean PDF" Macro
Exports the active document as a high-resolution PDF in the same folder with the same file name, without going through Export menus:
Sub QuickExportPDF()
Dim pdfPath As String
pdfPath = Replace(ActiveDocument.FullName, ".docx", ".pdf")
pdfPath = Replace(pdfPath, ".docm", ".pdf")
ActiveDocument.ExportAsFixedFormat OutputFileName:=pdfPath, _
ExportFormat:=wdExportFormatPDF, OpenAfterExport:=True
End Sub
How to Paste VBA Code into Word
- 1Press Alt + F11 to open the VBA Editor.
- 2In the Project Explorer on the left, double-click Normal > Modules > NewMacros.
- 3Paste the code at the bottom of the window.
- 4Press Ctrl + S to save. Close the editor.
- 5The macro is now ready to run from your Macros dialog or custom button!
Interactive Quiz
Multiple Choice Questions
Question 1
What is the keyboard shortcut to launch the Visual Basic for Applications (VBA) Editor in MS Word?
Question 2
In VBA code, which object represents the currently selected text on the document canvas?
Question 3
What programming language underlies recorded macros in Microsoft Office applications?
Question 4
In the VBA Project window, which module store ensures code runs across all documents on your system?
Question 5
What VBA method exports an active Word document into a standard PDF file programmatically?
Next Lesson
Creating & Using Templates
Continue learning with hands-on practice, examples, and exercises in the upcoming topic.
Related Lessons
| Previous Lesson | Next Lesson |
|---|---|
| Assigning Macros to Buttons | Creating & Using Templates |
Practice Quiz
Test your understanding of this lesson with 5 questions. Each question has one correct answer.