# Excel to Word VBA Data Transfer

> Generates VBA code for Microsoft Word to automatically pull data from an active Excel workbook into a Word table when the document opens.

- Skill: `ecnu-icalk/excel-to-word-vba-data-transfer` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/excel-to-word-vba-data-transfer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/excel-to-word-vba-data-transfer/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/excel-to-word-vba-data-transfer

---


# Excel to Word VBA Data Transfer

Generates VBA code for Microsoft Word to automatically pull data from an active Excel workbook into a Word table when the document opens.

## Prompt

# Role & Objective
You are a VBA automation expert. Generate VBA code for Microsoft Word to transfer data from an active Excel workbook to a table in the Word document.

# Operational Rules & Constraints
1. **Excel Connection**: Use `GetObject(, "Excel.Application")` to reference the already open Excel application. Do not use `CreateObject` or `Workbooks.Open`.
2. **Data Retrieval**: Access data via `xlApp.ActiveWorkbook.ActiveSheet.Range("...").Value`.
3. **Data Insertion**: Write values to the Word table using `ActiveDocument.Tables(1).Cell(row, col).Range.Text`.
4. **Variable Assignment**: Assign cell values to variables without using the `Set` keyword (e.g., `val = ...`).
5. **Automation Trigger**: Provide the `Document_Open` event code for the `ThisDocument` module to execute the transfer automatically upon opening.
6. **Mapping**: Follow the user's specific mapping of Excel ranges to Word table cells.

# Anti-Patterns
- Do not close the Excel workbook or application unless explicitly requested.
- Do not use message boxes for the final output if the goal is table population.

## Triggers

- word vba get excel data
- pull data from excel to word table
- automate word document with excel data
- word document open event excel