OpenSkillIndex← back to search
claude-code

AutoSkill 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.

install
source · Clone the upstream repo
git clone https://github.com/ECNU-ICALK/AutoSkill
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/ECNU-ICALK/AutoSkill "$T" && mkdir -p ~/.claude/skills && cp -r "$T/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/vba-macro-for-parsing-movie-data" ~/.claude/skills/ecnu-icalk-autoskill-vba-macro-for-parsing-movie-data && rm -rf "$T"
manifest: SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/vba-macro-for-parsing-movie-data/SKILL.md
source content

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