Automate Excel, without buying software
Four guides to understanding the mechanics of Excel automation: you will find the essential principles in VBA, the technical traps that cost hours, and an honest appraisal of what separates a script from a finished tool.
Creating folders automatically from Excel
The VBA principle for creating folders from Excel, and why doing it yourself soon gets complicated.
Read the guide →Making a Gantt chart in Excel
Two formulas, some conditional formatting, and your schedule draws itself — French public holidays included.
Read the guide →Filling a Word document from Excel
How to drive Word from Excel in VBA: an overview of the principle, and the limits of a home-made job.
Read the guide →Adding your own buttons to the Excel ribbon
A tab in your name, your buttons, your icons: the customUI XML explained, and the traps that make the ribbon disappear.
Read the guide →Why these guides are free
We share the broad technical principles of Excel automation through targeted extracts (~10% of the code, enough to grasp the logic). But between a theoretical sketch and a robust everyday tool lies a world: forbidden characters, recursive trees, OneDrive conflicts, ghost Word processes and an ergonomic ribbon. Our €19 add-ins save you precisely those dozens of hours of development and maintenance.
A question about one of these guides, or a case we have not covered? Write to us : the useful answers end up in the guides.