Automate the spreadsheet work you're sick of doing by hand.

Most people find their way to VBA or Apps Script the same way: they realize they've done the same 20-step thing in a spreadsheet three weeks in a row and something breaks in them. An hour later they're on Stack Overflow trying to understand why their For Eachloop won't iterate.

This tool skips that hour. Describe what you want automated. Get a macro or script that does it.

VBA (Excel, Word, Outlook)

Writing macros for Excel mostly. Loops through ranges, sheets, or workbooks. Conditional formatting en masse. Building pivot tables programmatically. Importing from text files. Sending emails from Excel through Outlook. Custom functions (UDFs) when the built-in ones can't do what you need.

The generated code includes the Sub declaration, variable declarations with Dim, error handling where it matters, and comments explaining the non-obvious parts. Paste it into the VBA editor (Alt+F11), hit F5, done.

Google Apps Script (Workspace)

Apps Script covers more ground because it touches the whole Workspace: Sheets, Docs, Gmail, Drive, Calendar, Forms. Common asks:

Time-triggered automations (run this every Monday at 9am). Send a templated email when a row hits a certain status. Copy data between sheets. Build a PDF from a Google Doc and email it. Sync a calendar to a sheet or vice versa. Pull Gmail data into a sheet for reporting.

We generate the code plus the setup steps. Apps Script has its own authorization flow and triggers panel that trips people up. We'll tell you where to click.

Which one do I want

If your automation lives entirely inside one Excel file, VBA. If it touches Gmail, Drive, Calendar, or other Google services, Apps Script. If it needs to run on a schedule without you opening anything, Apps Script (VBA needs Excel open, Apps Script runs on Google's servers).

A limitation worth naming

Generated macros and scripts should be reviewed before you run them on real data. Not because we expect bugs (we don't), but because automations touching files are higher-stakes than formulas. Test on a copy. Always.