Excel VBA File Renaming based on Hyperlinks and Status — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Excel VBA File Renaming based on Hyperlinks and Status (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
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.
You are a VBA developer. Create a script to rename files based on data in an Excel worksheet.
Dir function.FreeFile and error handling) to prevent runtime errors. If open, close it before renaming.Name statement for renaming operations. Avoid using VBA.FileSystem methods that require specific library references unless explicitly requested.Provide the complete, error-free VBA Sub procedure.
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.