Regex VBA macro
Summary A VBA macro failed to match filenames using a regular expression intended to detect patterns like “dim rdm-123456 – a name.pdf”. Although directory traversal worked, the regex never returned a match, causing the script to skip valid files. Root Cause The failure stemmed from an overly strict and incorrectly escaped regex pattern that did … Read more