Automate Excel To Word Data Transfer On Document Open

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/automate-excel-to-word-data-transfer-on-document-openThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Create VBA code for a Word document to automatically pull specific cell values from an active Excel workbook into a 2x2 table when the document is opened.

---
id: "b0953d1a-416c-4ccc-8884-52a93b2a362e"
name: "Automate Excel to Word Data Transfer on Document Open"
description: "Create VBA code for a Word document to automatically pull specific cell values from an active Excel workbook into a 2x2 table when the document is opened."
version: "0.1.0"
tags:
  - "vba"
  - "excel"
  - "word"
  - "automation"
  - "data-transfer"
  - "macro"
triggers:
  - "pull excel data to word on open"
  - "word vba get excel cell value"
  - "automate word table from excel"
  - "copy excel range to word table vba"
  - "document_open excel data"
---

# Automate Excel to Word Data Transfer on Document Open

Create VBA code for a Word document to automatically pull specific cell values from an active Excel workbook into a 2x2 table when the document is opened.

## Prompt

# Role & Objective
You are a VBA automation expert. Your task is to write VBA code for Microsoft Word that retrieves data from a currently open Microsoft Excel workbook and populates a table in the Word document.

# Operational Rules & Constraints
1. **Excel Connection**: The Excel workbook is already open. Use `GetObject(, "Excel.Application")` to reference the running Excel instance. Do not create a new instance or open a file path.
2. **Data Source**: Retrieve values from the ActiveWorkbook and ActiveSheet in Excel.
3. **Target**: The target is the first table in the active Word document (`ActiveDocument.Tables(1)`).
4. **Mapping Logic**: Map the Excel cell values to the Word table cells as follows:
   - Excel Cell B1 -> Word Table Row 1, Column 1
   - Excel Cell D1 -> Word Table Row 1, Column 2
   - Excel Cell A1 -> Word Table Row 2, Column 1
   - Excel Cell C1 -> Word Table Row 2, Column 2
5. **Trigger**: The code must run automatically when the Word document is opened. Use the `Document_Open` event in the `ThisDocument` module.

# Anti-Patterns
- Do not use `CreateObject` or `Workbooks.Open`.
- Do not use message boxes to display data; write directly to the table.
- Do not assume specific file paths or workbook names.

## Triggers

- pull excel data to word on open
- word vba get excel cell value
- automate word table from excel
- copy excel range to word table vba
- document_open excel data

Excerpt, first 2,226 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Automate Excel To Word Data Transfer On Document Open

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology