Making Your Script Unstoppable – Advanced Error Handling

by

In the SCM Automation Lab, we don’t just write code that “works.” We write code that lasts. If you click your automation button while SAP is already logged in, or if you have a typo in your server name, a basic script will simply “crash.” Today, we will learn how to make your VBA script … Read more

The Full Pipeline – Merging SAP Logon and Data Extraction

by

Until now, we have treated “Logging in” and “Running a Report” as two separate steps. But in a high-efficiency SCM environment, every second counts. Today, we will merge our previous scripts into one Seamless Automation Pipeline. Imagine arriving at your desk, clicking a single button in Excel, and watching your SAP data populate instantly while … Read more

Pulling Real-Time Data – Automating SAP MB52 Stock Reports

by

In our previous posts, we set up our environment and automated the logon process. Now, it’s time for the “Real Magic”: Extracting data. As an SCM professional, you likely spend a lot of time running MB52 (Warehouse Stock) or similar reports. Instead of manually entering plants and material types every morning, let’s make Excel do … Read more

One-Click Entry – Automating Your SAP Logon with Excel VBA

by

If you are an SCM professional, you probably start your day with a routine: Open SAP Logon, find the server, type your ID, and then your password. It’s a repetitive “digital chore” that drains your focus before the real work even begins. In the SCM Automation Lab, we believe in working smarter. Today, we will … Read more

Summing Only Visible Data After Excel Filtering: Utilizing the SUBTOTAL Function

by

1. Problem Situation In real-world data handling, it is often necessary to apply filtering to a large data table based on specific criteria (e.g., specific period, particular department) and then calculate the sum of only the cells visible on the screen. If you use the standard SUM function (e.g., =SUM(A1:A10)), it includes the values from … Read more