Site Tools


services:scripting

Scripting

About

Scripting allows you to automate frequent computer tasks like backing up folders and processing data.

VBA

VBA is great for automating tasks in Microsoft office. It integrates tightly with the applications allowing for detailed control. Most of my experience is manipulating data in Excel. VBA allows extending Excel to be very powerful by adding custom buttons and functions. Most frequent tasks in excel can be reduced to a single click.

Python

Python is great for manipulating data and creating reports. It has a lot of powerful libraries for processing data. This is a great step up from VBA if you need something more powerful. Most of my experience is with a library called Mathplotlib that allows for detailed and visually pleasing representation of data.

AHK

AutoHotKey is meant for binding hotkeys to common tasks. It can be used to automate interaction with forms that need to be completed frequently or to open frequently used applications. It is also excellent at navigating deep application menus or typing frequent responses with the press of a button.

Relevant Projects

services/scripting.txt · Last modified: 2025/01/26 by admin