code Macro bank

Automation Excel Macros

Reusable, well-commented VBA macros. No VBA? In ExcelBot you ask the AI for the same thing in plain language.

All Data Tools 5 Automation 5
Macro Combine All Sheets
Automation

Combine All Sheets

Merge every worksheet into one master sheet.

download bas 1 KB
Macro Export Sheet to PDF
Automation

Export Sheet to PDF

Save the active sheet as a PDF next to your workbook.

download bas 1 KB
Macro Email Workbook via Outlook
Automation

Email Workbook via Outlook

Attach the current workbook to a new Outlook email.

download bas 1 KB
Macro Loop Through Files in a Folder
Automation

Loop Through Files in a Folder

Open every Excel file in a folder and process it.

download bas 1 KB
Macro Create a Table of Contents
Automation

Create a Table of Contents

Build a TOC sheet linking to every worksheet.

download bas 1 KB