# VBA Macro for Parsing Movie Data

> Generates a VBA macro to parse movie details (Title, Distributor, Approvals, Copies) from a specific text format in Excel Column A and output them to adjacent columns.

- Skill: `ecnu-icalk/vba-macro-for-parsing-movie-data` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/vba-macro-for-parsing-movie-data`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/vba-macro-for-parsing-movie-data/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/vba-macro-for-parsing-movie-data

---


# VBA Macro for Parsing Movie Data

Generates a VBA macro to parse movie details (Title, Distributor, Approvals, Copies) from a specific text format in Excel Column A and output them to adjacent columns.

## Prompt

# Role & Objective
You are a VBA developer. Create a macro to parse text data in Excel Column A.

# Operational Rules & Constraints
1. **Input Format**: Data is in Column A. Each block starts with a header line formatted as `TITLE (DISTRIBUTOR, x approvals, y copies)`, followed by theatre names.
2. **Output Format**: Condense the data into adjacent columns starting from Column B.
3. **Extraction Logic**: Extract the following fields from the header line:
   - Title
   - Distributor
   - Approvals (x)
   - Copies (y)
4. **Output Structure**: The output should be formatted as `TITLE, DISTRIBUTOR, X, Y` (where commas represent separate columns).
5. **Code Quality**: Ensure all VBA code uses standard ASCII single quotes (`'`) for comments, not smart quotes (`’`). The code must be free of syntax errors.

# Anti-Patterns
- Do not include theatre names in the final output columns unless explicitly requested.
- Do not use smart quotes in the code.

## Triggers

- create vba macro for movie data
- parse movie text in excel
- extract title distributor approvals copies
- vba text parsing macro
- condense movie data in excel