Automating Excel VBA File Renaming with Dir and Name: 3 Steps to Reduce 200 Voucher PDF Renames from 2 Hours to 5 Minutes per Month

Have you ever seen a folder filled with 200 files named "Scan_0001.pdf"?There was a sticky note on the monitor of K, who ...

Creating VBA to Automatically Reflect Margin Trading Ratios in Excel

Last time, I updated the program that converts the "Margin Trading Balance by Stock" PDF published by JPX into Excel using Python.Since the PDF format changed in September 2026 and the previous ...