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.
npx skills add ECNU-ICALK/AutoSkill --skill automate-excel-to-word-data-transfer-on-document-open --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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. Us
- Prompt
- Triggers
What does the Automate Excel to Word Data Transfer on Document Open skill do?
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.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill automate-excel-to-word-data-transfer-on-document-open --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.