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.
npx skills add ECNU-ICALK/AutoSkill --skill vba-macro-for-parsing-movie-data --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.
# 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 -
- Prompt
- Triggers
What does the VBA Macro for Parsing Movie Data skill do?
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.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill vba-macro-for-parsing-movie-data --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.