nazmulhudha/office-automation-toolkit

Office Pro Premium Suite is a collection of automation tools for Microsoft Excel, Word, and PowerPoint. It combines VBA macros, Power Query transformations, and Office scripts so you can automate repetitive tasks across the three applications instead of handling each one separately. For Excel, it offers macro scheduling that can run at set intervals even when Excel is closed using Windows Task Scheduler, automatic backups before macros run with rollback if something goes wrong, and Power Query pipelines meant to clean and reshape raw data into dashboards with conditional formatting. For PowerPoint, it provides templates that keep fonts, colors, and spacing consistent across a presentation, and can pull live data from Excel sheets directly into slides so they update automatically when the source data changes. For Word, it can assemble documents from boilerplate text and variable data, apply custom fields and conditional content to templates, and normalize formatting across documents written by multiple authors. Configuration is done through a YAML profile file where you set defaults like which workbook or template to use, macro security level, and scheduled automations such as a weekly report generator that fetches data, applies a Power Query transform, builds charts, and exports a PDF. There is also a command line interface for running these automations directly. The toolkit includes optional integrations with the OpenAI and Claude APIs, letting you ask for things like a formula in plain language and have it inserted into a selected Excel cell, or generate narrative summaries of your data. Platform support is strongest on Windows 10 and 11, with close feature parity on macOS, and only core features on Linux. Multiple language support is included for the interface and templates, with some languages listed as coming later.