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 ...

“Moving away from VBA” does not mean throwing it away—How to inventory Excel tasks and what to migrate to in the era of macro blocking and the deprecation of VBScript

A practical guide for DX personnel, internal IT staff, and accounting staff at small and medium-sized enterprises (as of September 2026)Introduction“The Excel macro I received from a business partner ...
Ars Technica

Excel gets containerized, cloud-based Python analytics and visualization powers

If you’re decent in Python (or aspire to be) but don’t have the chops for advanced data work in Excel, Microsoft now offers the kind of peanut butter-and-chocolate combination that you may consider a ...
Computerworld

How to use Excel macros to save time and automate your work

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you. If you regularly work with Excel spreadsheets, you probably find yourself repeating ...