SAP GUI Scripting Lesson 2: Recording Your First Script
Record a script with Script Recording and Playback: start recording, run a report, stop, find the .vbs file and replay it, with tips for…
Read article →Automation
Stop doing it by hand: VBA, Python, SAP GUI scripting, Power Automate, Office Scripts and AutoHotkey.
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 scripting parameter must be…
Read article →SAP GUI Scripting Lesson 4: Running SAP From Excel VBA
SAP GUI Scripting Lesson 4: Running SAP From Excel VBA
Drive SAP from an Excel macro: attach to the running session, read selection values from cells, run the report, and handle the most common…
Read article →Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
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 →Power Automate: A Daily Email Summary of New SharePoint List Items
Power Automate: A Daily Email Summary of New SharePoint List Items
Build a scheduled flow that collects yesterday's new SharePoint list items, formats them as a table and emails one tidy summary each morning —…
Read article →Office Scripts Lesson 5: Run Scripts From Power Automate
Office Scripts Lesson 5: Run Scripts From Power Automate
Schedule Office Scripts with Power Automate: Run script action, passing parameters in and returning results, daily refresh of a report file, and emailing the…
Read article →Office Scripts Advanced: Tables, Charts and Automation
Office Scripts Advanced: Tables, Charts and Automation
Clean exports with Office Scripts: trim and case text, convert text numbers, remove blank rows, number formats, conditional formatting and freeze panes.
Read article →Office Scripts Basics: Automate Excel in the Browser
Office Scripts Basics: Automate Excel in the Browser
Find the used range, add tables, read and add table rows, sort and filter tables, and total columns — the core of most Office…
Read article →Office Scripts Lesson 2: TypeScript Basics for Excel Users
Office Scripts Lesson 2: TypeScript Basics for Excel Users
The TypeScript you need for Office Scripts: let and const, types, if, for loops, arrays from getValues(), functions and console.log for debugging.
Read article →Office Scripts Lesson 1: What Office Scripts Are and the Action Recorder
Office Scripts Lesson 1: What Office Scripts Are and the Action Recorder
Meet Office Scripts: where the Automate tab is, licences, recording actions, reading the generated TypeScript, and how Office Scripts differ from VBA.
Read article →Python: Rename Hundreds of Files From an Excel List
Python: Rename Hundreds of Files From an Excel List
Rename scanned invoices, photos or reports in bulk using an Excel sheet of old and new names — with a dry run, a log,…
Read article →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 →