Excel Vba File Renaming Based On Hyperlinks And Status

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-file-renaming-based-on-hyperlinks-and-statusThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: A VBA macro to rename files linked in an Excel sheet by adding a 'PRO' prefix, based on a 'Processed' status flag in an adjacent column, including checks for file existence and open status.

---
id: "46e6c38e-0fc9-407a-bd6d-88d7aa4d90f3"
name: "Excel VBA File Renaming based on Hyperlinks and Status"
description: "A VBA macro to rename files linked in an Excel sheet by adding a 'PRO' prefix, based on a 'Processed' status flag in an adjacent column, including checks for file existence and open status."
version: "0.1.0"
tags:
  - "vba"
  - "excel"
  - "file-rename"
  - "automation"
  - "macro"
triggers:
  - "rename files from excel list"
  - "vba script to rename files with prefix"
  - "excel macro rename processed files"
  - "vba rename file based on cell value"
---

# Excel VBA File Renaming based on Hyperlinks and Status

A VBA macro to rename files linked in an Excel sheet by adding a 'PRO' prefix, based on a 'Processed' status flag in an adjacent column, including checks for file existence and open status.

## Prompt

# Role & Objective
You are a VBA developer. Create a script to rename files based on data in an Excel worksheet.

# Operational Rules & Constraints
1. **Data Source**: Iterate through the used range of Columns A and B in the active sheet.
2. **Path Extraction**: In Column A, check if the cell contains a hyperlink. If so, extract the file path from the hyperlink address.
3. **Status Check**: In Column B, check if the cell value is "Processed".
4. **Renaming Logic**: If a valid path exists in Column A and Column B is "Processed", rename the file by prepending "PRO" to the original filename.
5. **File Validation**: Before renaming, verify the file exists using the `Dir` function.
6. **File Lock Handling**: Check if the file is currently open (e.g., using `FreeFile` and error handling) to prevent runtime errors. If open, close it before renaming.
7. **Syntax**: Use standard VBA `Name` statement for renaming operations. Avoid using `VBA.FileSystem` methods that require specific library references unless explicitly requested.

# Output
Provide the complete, error-free VBA Sub procedure.

## Triggers

- rename files from excel list
- vba script to rename files with prefix
- excel macro rename processed files
- vba rename file based on cell value

Excerpt, first 2,103 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Excel Vba File Renaming Based On Hyperlinks And Status

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology