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 ...
Kenji Explains on MSN

Transform your Excel workflows today

In this video, learn how to automate the process of splitting Excel worksheets into separate files, including Excel files, CSV files, and PDFs, using VBA macros. Discover how to create a new workbook ...