Projects & Assignments done so far


Automating Document Template Migration Using VBA

Migrating documentation from legacy formats to a standardized document template can be a time-consuming and repetitive task. When multiple documents require the same formatting updates, manual migration often leads to inconsistencies, increased review effort, and unnecessary productivity loss.

To address this challenge, I developed a VBA-based automation solution that streamlines the migration of Microsoft Word documents by automatically applying standard document styles and processing multiple files in a single run.

The Challenge

Organizations frequently update their documentation standards, templates, and branding requirements. As a result, existing documents may need to be migrated to a new template structure while maintaining content accuracy and document hierarchy.

The primary challenges typically include:

  • Large volumes of documents requiring migration
  • Inconsistent heading styles
  • Manual formatting effort
  • Formatting errors introduced during copy-paste activities
  • Lengthy review cycles

The Solution

The solution uses Microsoft Word VBA to automate the migration process. Instead of manually reformatting each document, the automation allows users to select a template, choose a source folder, and process multiple documents automatically.

The automation performs the following actions:

  1. Select a standard Word template
  2. Select a folder containing source documents
  3. Select a destination folder for migrated documents
  4. Open each document automatically
  5. Apply the selected template
  6. Update document styles
  7. Convert predefined heading styles
  8. Save migrated copies without modifying original files

Style Mapping Approach

Many legacy documents use custom heading styles that differ from standard Word styles. The automation uses style mapping to convert legacy headings into standardized heading levels.

  • Custom Heading 1 → Heading 1
  • Custom Heading 2 → Heading 2
  • Custom Heading 3 → Heading 3
  • Custom Heading 4 → Heading 4

This ensures consistent document structure and allows features such as automatic table of contents generation and navigation to work correctly.

Workflow

  1. Review source and target templates
  2. Launch the VBA automation
  3. Select the standard template file
  4. Select the source document folder
  5. Select the destination folder
  6. Run the automated conversion
  7. Perform a final quality review

Benefits

  • Reduces manual formatting effort
  • Processes multiple documents in a single execution
  • Improves consistency across documentation sets
  • Preserves original source files
  • Accelerates migration projects
  • Reduces formatting-related review comments
  • Supports documentation standardization initiatives

Results

The automation significantly reduces the time required to migrate documentation while maintaining a consistent structure across documents. Instead of manually updating each file, users can process large batches of documents with minimal effort and focus more on content quality and technical accuracy.

Technologies Used

  • Microsoft Word
  • Visual Basic for Applications (VBA)
  • Word Templates
  • Style Mapping
  • Document Migration
  • Process Automation

Key Takeaways

This project demonstrates how automation can improve documentation workflows by reducing repetitive manual work and increasing consistency. By combining technical writing expertise with VBA development, it is possible to create practical solutions that enhance documentation quality and efficiency at scale.

GA & Layout of Carton Packing & Conveying System


Objective of the Project

The primary aim of the system is to prepare the cartons, load them with airbags, package the same, and subsequently convey these prepared cartons to the dispatch area. This system comprises a conveyor, an airbag production machine, a flap-closing and taping machine, as well as a strapping machine.

Steps involved in this process:

  • Preparing cartons
  • Filling cartons with airbags
  • Packing and sealing the cartons
  • Conveying cartons to dispatch area

Tools used to prepare the layout:

Autodesk Inventor, AutoCAD

Creating a Customized Bullet in FrameMaker

Objective

In this module, the user will learn about creating the custom bullet in Adobe FrameMaker. This module is intended to be used by users who are new to Adobe FrameMaker

Introduction to Adobe FrameMaker

Adobe FrameMaker is the industry-standard tool for authoring and publishing multilingual technical content across mobile, web, desktop, and print. Structured FrameMaker is used to achieve consistency in documentation within industries such as aerospace, where several models of the same complex product exist, or pharmaceuticals, where translation and standardization are important requirements in communications about products. Unstructured FrameMaker uses tagged paragraphs without any imposed logical structure, except that expressed by the author’s concept, topic organization, and the formatting supplied by paragraph tags.

Role of Bullets in Documents

There are two types of common lists you can use in a document:

Bulleted Lists:

  • Bullets are used to list the items where sequence is not important.
  • Bullets are used to identify the key items or denote significance in any type of documents.

Numbered Lists:

  • Numbers are used to list the items and to write the process where sequence is important.

In this document, we will learn to create customized bullets in Adobe FrameMaker.

Creating a Bullet in Adobe FrameMaker

The process of creating a customized bullet in adobe FrameMaker essentially consist of two major steps:

  1. Designing a Character tag
  2. Creating a Custom Bullet

Designing a Character Tag

  1. To open a new document, go to the File > New > Document or press Ctrl + N key.
  2. To create a new document, select Portrait from the New dialog box.
  3. To open the Character Designer dialog box, go to the Format > Character > Character Designer or press Ctrl+D.
    The following dialog box appears.
  4. Enter the style name in the Style field.
  5. Select 12.0 pt in the Size field.
  6. From the Family pull-down menu, select Webdings.
  7. From the Color pull-down menu, select Black.
  8. Select Create Style.

Result: Character has been designed.

Creating a Customized Bullet

  1. To open the Character Palette, go to the File > Utilities > Character Palette.
    The Character Palette dialog box appears.
  2. From the font pull-down menu, select font Wingdings.
  3. To insert the desired character in the document, select the character and click the mouse twice in rapid succession.
  4. To open the Paragraph Designer dialog box, go to the Format > Paragraph > Paragraph Designer or press Ctrl+M.
    The following dialog box appears.
  5. Select Numbering in the Paragraph Designer dialog box
  6. To enable the Format field, select the Autonumber Paragraphs checkbox.
  7. Copy the character from the document and paste it into the Format field.
  8. To create the bullet, select Update Style and then select Apply.

Result: Bullet has been created successfully.