Power Automate Lesson 5: Approvals
Build an approval flow: start and wait for an approval, approve from email, Teams or mobile, branch on the outcome, and record decisions in…
Read article →Automation
Stop doing it by hand: VBA, Python, SAP GUI scripting, Power Automate, Office Scripts and AutoHotkey.
Power Automate Lesson 2: Your First Cloud Flow — Email Alerts
Power Automate Lesson 2: Your First Cloud Flow — Email Alerts
Build a flow that sends a Teams or mobile notification when an important email arrives: trigger conditions, dynamic content, testing and turning flows on…
Read article →Power Automate Lesson 1: What Power Automate Is (Cloud vs Desktop)
Power Automate Lesson 1: What Power Automate Is (Cloud vs Desktop)
Understand Power Automate: cloud flows vs desktop flows, triggers and actions, connectors, licences included with Microsoft 365, and what to automate first.
Read article →Office Scripts in Excel for the Web: Your First Script, Explained Like VBA
Office Scripts in Excel for the Web: Your First Script, Explained Like VBA
What Office Scripts are, how they differ from VBA, how to record and edit a script, a real clean-up example in TypeScript, and how…
Read article →Python: Pull Data From an API Into a Formatted Excel Report
Python: Pull Data From an API Into a Formatted Excel Report
A complete Python script that calls a JSON API, reshapes the data with pandas, and writes a formatted Excel report with openpyxl — ready…
Read article →SAP GUI Scripting Lesson 5: Loops, Errors and Exports to Excel
SAP GUI Scripting Lesson 5: Loops, Errors and Exports to Excel
Make SAP scripts robust: loop over a list of company codes, export ALV lists to a file, check for popups and status-bar messages, and…
Read article →SAP GUI Scripting Lesson 3: Understanding the Recorded VBScript
SAP GUI Scripting Lesson 3: Understanding the Recorded VBScript
Read a recorded SAP script: the application-connection-session objects, findById paths, text, press and sendVKey, and how to replace hard-coded values with variables.
Read article →SAP GUI Scripting Lesson 1: What It Is (and Permissions)
SAP GUI Scripting Lesson 1: What It Is (and Permissions)
Understand SAP GUI scripting: what it can automate, server and client settings (sapgui/user_scripting), security prompts, and when to use it versus BAPIs or standard…
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 →Python: Sort a Messy Downloads Folder by Year and Month
Python: Sort a Messy Downloads Folder by Year and Month
A 25-line Python script that moves files into Year/Month folders based on their modified date, with a dry-run mode so you can check before…
Read article →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 data that you can…
Read article →