Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
Step-by-step: enable SAP GUI Scripting, record a transaction, and run it from Excel VBA to export a report automatically.
Read article →Category Archives: Automation
Stop doing it by hand: VBA, Python, SAP GUI scripting, Power Automate, Office Scripts and AutoHotkey.
Office Scripts: Automate Excel on the Web Without VBA
Office Scripts: Automate Excel on the Web Without VBA
Office Scripts bring automation to Excel for the web and Microsoft 365. Record a script, read the TypeScript it creates, and write a report-formatting…
Read article →MaxL Basics: Automate Essbase Data Loads and Calculations
MaxL Basics: Automate Essbase Data Loads and Calculations
Use MaxL scripts to automate Essbase: log in, clear and load data with a rules file, run a calculation and log errors — with…
Read article →AutoHotkey: Text Expansion and Hotkeys That Save Hours Every Week
AutoHotkey: Text Expansion and Hotkeys That Save Hours Every Week
Use AutoHotkey v2 on Windows to expand abbreviations into full text, insert today’s date, and launch apps with shortcuts — with a starter script…
Read article →Refresh Oracle Smart View Sheets Automatically with VBA
Refresh Oracle Smart View Sheets Automatically with VBA
Use the Smart View VBA functions HypConnect, HypRetrieve and HypDisconnect to refresh every Essbase/EPM sheet in a workbook with one click.
Read article →Python for Office Automation: The Complete Starter Guide
Python for Office Automation: The Complete Starter Guide
Use Python to automate everyday office work: set up Python, handle files and folders, read and write Excel, create Word reports, send emails safely,…
Read article →Merge 100 Excel Files into One with Python (in 10 Lines)
Merge 100 Excel Files into One with Python (in 10 Lines)
Combine every Excel file in a folder into one sheet with Python and pandas — with a source column, header checks and a summary.
Read article →Power Automate: Save Email Attachments to OneDrive Automatically
Power Automate: Save Email Attachments to OneDrive Automatically
Build a Power Automate cloud flow that saves attachments from specific Outlook emails into OneDrive or SharePoint folders — with filters, date folders and…
Read article →Power Automate Desktop: Build Your First Flow to Rename and Sort Files
Power Automate Desktop: Build Your First Flow to Rename and Sort Files
Build a first Power Automate Desktop flow that renames downloaded reports with today’s date and moves them into monthly folders — step by step,…
Read article →Which Automation Tool Should You Learn? VBA vs Python vs Power Automate vs SAP Scripting
Which Automation Tool Should You Learn? VBA vs Python vs Power Automate vs SAP Scripting
A practical guide to choosing between Excel VBA, Python, Power Automate and SAP GUI scripting for automating office work — based on the task,…
Read article →Recording the Sap Macro
Recording the Sap Macro
Recording the Sap Macro When you are ready to perform the recording, be sure you know the transaction you want to execute and the…
Read article →Enable GUI Script Recording – SAP
Enable GUI Script Recording – SAP
Enable GUI Script Recording - SAP This document describes how you can turn on GUI Script Recording. To use GUI Script Recording with Winshuttle Transaction, the…
Read article →