agentsclimarketplace

Excel to word vba data transfer

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-to-word-vba-data-transfer

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill excel-to-word-vba-data-transfer

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

What its author says it does

Copied from the file, not written here

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

SKILL.md

1.9 KB, as published. Nobody here has run it

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

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.