Microsoft Office Automation VBA

💼 A professional collection of VBA macros demonstrating automation capabilities across Microsoft Office applications.

This project demonstrates:

• Legacy system integration via VBA
• Strong understanding of Excel functions and reporting
• Transition from Excel formulas (Intermediate Office skills) to VBA scripts (Advanced Office skills)

---

🧰 What You'll Find

🖥️ VBA Automation

• PowerPoint: A dynamic presentation generator with UserForm input
  • PowerPoint VBA
• Excel: Useful macros for data transformation and automation
  • Excel VBA
• Word: Template-based document generation tools
  • Word VBA
• Outlook: Automation of Emails for Security Information, Audits, Safety and Compliance
  • 29 Outlook VBA Scripts for Automation

Tip

All VBA scripts are files ready to import into the VBA editor.
Each script is standalone and can be extended into larger automation pipelines.

---

📊 Excel Formulas - 🚧 Under Construction - Last Update: June 22, 2025.

A dedicated folder containing practical use cases of advanced Excel formulas, including:

• Lookup functions (INDEX, MATCH, XLOOKUP)
• Conditional logic (IF, IFS, SWITCH)
• Aggregation with conditions (SUMIFS, COUNTIFS)
• Dynamic arrays (FILTER, SORT, UNIQUE)
• Pivot table preparation and cleanups

For showcasing analytical thinking and non-VBA problem-solving.

---

📌 Requirements

Each Python folder may include its own requirements.txt.
To run VBA scripts, simply import them into the appropriate Office app's VBA editor.

---

📂 Folder Structure

Office-Automation-Suite/
│
├── VBA/
│   ├── PowerPoint/
│   │   └── Big Form PPT automation
│   ├── Excel/
│   │   └── Excel macros 
│   └── Word/
│   │   └──  Word macros 
│   └──  Outlook/
│       └──  VBA macros for Outlook
├── Excel-formulas/
│   └── .xlsx files and/or formulas
│
└── README.md

---

📚 License

MIT License – see LICENSE for details.

---

About the Author

Thiago Maria - From Brazil to the World 🌎
Senior Security Information Professional | Passionate Programmer | AI Developer

With a professional background in security analysis and a deep passion for programming, I created this repo share some knowledge about security information, vba and automation for Microsoft Office tools. Most of my work here focuses on implementing security-first approaches in automation while maintaining usability.

Lets Connect:

Ways to Contribute:

Want to see more upgrades? Help me keep it updated!