ENFR
Request a quotation
Bespoke development · from €500 incl. VAT

Your trade has its own gestures.
Your Excel ribbon should have them too.

A tab in your name inside Excel, with your buttons: call the official API of the tool you already use, launch your Python script, check a 40,000-row sheet, follow statuses, import documents, turn out a finished deliverable. What takes you twelve operations becomes one click.

See a ribbon in action Request a free quotation
✉️ Detailed quotation within 48 working hours 🔓 Source code delivered and commented 🚫 No subscription, no lock-in

Click a button: see what is behind it

Three ribbons built for three different trades. Each button shows what it does, how it is wired, an extract of the code actually delivered, and the result in the sheet. Switch tabs to switch trade.

Workbook.xlsm — Excel custom ribbon
👆 Every button above is a real example. Click to open its sheet.

—

—

CODE

        

What the user sees

Sheet

Execution log

The code extracts are deliberately shortened (error handling and configuration removed) but faithful to what is delivered: readable VBA and standard Python, commented throughout.

What a custom ribbon can do

Eight families of functions, which combine. Most projects mix three or four of them: we start from your daily gesture, not from the technology.

🔌

The official APIs of your tools

If the software you use publishes an API, your ribbon can talk to it directly: no more double entry, no more manual export-import.

  • Public registers: company registry, addresses, land registry, energy data
  • Invoicing, banking, CRM, document management, ERP, ticketing tools
  • Token authentication, key stored outside the workbook
  • Sending and receiving: your data is pushed to the tool as well
🐍

Your Python scripts, launched in one click

Already have scripts that run on the command line? They become buttons, with their parameters taken from the sheet and the result fed back in.

  • The Excel selection becomes the script's input
  • Results read back automatically (CSV, JSON, images)
  • Python environment pinned, so it still works in 3 years
  • No black window: the user sees a progress bar
🧠

Your Python tools exposed as a service

When the computation is heavy or shared by the whole team, we expose it as a small local or server service, which Excel queries like any other API.

  • One calculation engine, several client workbooks
  • The engine is updated without touching the Excel files
  • Runs on the machine (127.0.0.1) or on your server
  • Ideal for your models, your rate tables, your in-house algorithms
🔍

Sheet analysis and checking

The button reads the whole sheet back and tells you what is wrong, before the client, the authorities or the auditor does.

  • Duplicates, gaps, inconsistent dates or amounts
  • Business validity rules (company number, IBAN, VAT, thresholds)
  • Two sheets reconciled row by row
  • Statistics and summaries recalculated on demand
🚦

Statuses, progress and alerts

One state per row, dates set automatically, a dashboard that updates itself and reminders that go out on their own.

  • Locked state cycle (impossible to skip a step)
  • Time stamps and log: who changed what, and when
  • Counters, overruns, indicators at the top of the sheet
  • E-mail alert or weekly summary
🎨

Special formatting

Your house style, your colour codes, your reading rules — applied in one click to any table, and reversible.

  • Advanced conditional formats, bars, gradients, icons
  • Subtotal rows, groupings, automatic outlines
  • Print layout and calibrated PDF export
  • Cleaning up badly formatted files you receive
📥

Document import

Files arriving by e-mail or through the portal become clean rows, with no copy-and-paste.

  • PDF, CSV, XML, bank statements, ERP exports
  • Tables extracted from a PDF, including scans (OCR)
  • Documents recognised and filed automatically
  • Filed in the right tree, renamed to your standard
📄

Your deliverables generated

The document you redo every week comes out of your own layout, filled in, saved in the right place and ready to send.

  • Word, PDF, or an Excel workbook from your templates
  • Mail merge in bulk: 120 letters in one pass
  • E-mail prepared in Outlook, attachments included
  • Numbering and naming that follow your rules
🗂️

Folders, naming and third-party software

The foundation of DossiersLocaux, extended without the 7-tool limit, and wired to the applications you keep open all day.

  • Complex trees, conditional on the type of project
  • Standardised naming, automatic project numbering
  • A trade application opened on the right client folder
  • Unlimited number of external tools

Three projects, told plainly

Cases representative of what is most often asked for. The figures are the ones reported by users after a few weeks of use.

🧾

Accountancy firm — 6 staff

Before: every new client file meant 20 minutes of typing, creating folders and copying the company number across from an official site.

The ribbon: one button creates the standardised tree, another completes the client record from the company registry API, a third checks the sheet (invalid company numbers, duplicates, inconsistent financial years) and a last one turns out the engagement letter as a PDF.

Result: 20 minutes brought down to under 2, and an end to wrong company numbers discovered at filing time.

🏗️

Design office — quantities and bills of quantities

Before: quantities were recalculated by hand in a workbook, and the client's bill of quantities was copied item by item from a PDF.

The ribbon: the in-house Python calculation engine, until then run on the command line by one person alone, became a service called from Excel; the PDF import fills the framework in 15 seconds.

Result: the whole office uses the same engine, and the rate table is updated in one single place.

🏠

Property management — 180 units

Before: rents received were ticked off row by row against the bank statement, then receipts generated one at a time.

The ribbon: statement imported, automatic reconciliation paid / partial / unpaid, colour-coded statuses, bulk generation of PDF receipts and e-mails, graduated reminders with a log.

Result: half a day recovered every month, and no more forgotten arrears.

Why stay in Excel

The usual reflex is to go for dedicated software or a web application. That is not always the right sum.

One more piece of software

  • A subscription per user, every month, forever
  • An interface to relearn, and newcomers to train
  • Your data goes to a vendor, in the vendor's format
  • Your trade's particularities? “That is not supported”
  • The day the vendor closes or triples its prices, you follow
  • An Excel export is still needed for everything else
VS

A ribbon inside your own Excel

  • Paid for once, used on as many machines as you like
  • The team already knows Excel: nothing to relearn
  • Your files stay with you, readable without any tool
  • Built exactly on your rules, exceptions included
  • Source code delivered: you are nobody's prisoner
  • Lives alongside your existing pivot tables and formulas

How it works

No 40-page specification for you to write: we start from your current file and from the way you work today.

1

Scoping conversation

30 to 45 minutes on the phone. You show your file and your usual operations; we spot what turns into buttons.

Free
2

Detailed quotation

Every button is priced separately, with any network calls listed in black and white for your IT department. You decide what you keep.

Within 48 working hours
3

Ribbon mock-up

You approve the tabs, the groups, the labels and the icons before a single line of business code is written.

A few days
4

Development and back-and-forth

Delivered in batches of buttons, tested on your real data. You correct course as you go, rather than at the end.

2 to 6 weeks depending on scale
5

Delivery and handover

Final workbook, commented source code, illustrated instructions and a handover session with the team. Then 30 days of corrections included.

30-day guarantee

What it costs

Indicative prices including VAT, to give you the order of magnitude before you even call us. The real quotation is drawn up item by item, and you are only committed once you have accepted it in writing.

First batch

from €500 incl. VAT

Two or three buttons that settle the most painful gesture.

  • A ribbon in your name, one tab
  • VBA functions built on your business rules
  • Sheet checks or formatting
  • Instructions and commented source code

Trade ribbon

€1,500 to €4,000 incl. VAT

The most frequent case: the whole chain, from data entry to deliverable.

  • Several groups of buttons, unlimited external tools
  • 1 to 2 connections to official APIs
  • Statuses, dashboard and alerts
  • Document import and deliverable generation
  • Deployment across all the machines
  • Handover session for the team

With a Python engine

on quotation

When a calculation, a model or a heavy process enters the loop.

  • Your existing scripts turned into production tools
  • Local or server service queried by Excel
  • Pinned environment and an installer for the IT department
  • Existing work taken over and documented

Included in every case

Always included
  • VBA and Python source code delivered, commented throughout
  • No subscription, no key to renew
  • Use on an unlimited number of machines within your organisation
  • Illustrated instructions and a handover session
  • 30 days of corrections after delivery
  • Your files stay your files, in their original format
To allow for, where applicable
  • Subscriptions to the third-party services you choose to query
  • The Microsoft Office licences of the machines concerned
  • An internal server, if you want to host the Python engine there
  • Changes requested after the guarantee period (by the half-day)

How an Excel ribbon is actually built

Our guide details the customUI file, the VBA callbacks, the Office icons and the mistakes that make the tab disappear. Enough to judge for yourself — or to do it yourself if your need fits in three buttons.

Read the guide “Adding your own buttons to the Excel ribbon” →

Frequently asked questions

Does anything have to be installed on the machines?

In most cases, no: the ribbon lives in the macro-enabled workbook (.xlsm), you just open it and allow macros once. An installation is only needed if the project embeds a Python runtime or a COM add-in — in which case a silent installer is provided to the IT department, with the list of what it puts down.

Does my data leave the company?

Only towards the services you explicitly ask to query, and only with the fields the call needs. A ribbon can perfectly well work entirely offline.

The addresses contacted and the data sent are listed in the quotation: your IT department approves before a single line is written.

And if the tool I use has no API?

That happens often. There is nearly always a way through: importing and exporting files in a watched folder, reading the software's database, driving its interface as a last resort, or going through the files it already produces (PDF, CSV). This feasibility is checked during scoping, before the quotation — and if no clean route exists, we say so rather than sell you a contraption.

Who owns the code that is developed?

You do. The code is delivered open and commented, with no obfuscation, no VBA project password, no licence to renew. You can modify it yourself, hand it to another supplier or share it internally.

Does it work on a Mac?

The custom ribbon and the VBA do work on Excel for Mac, but several of the building blocks used on Windows do not exist there: Outlook automation, some system calls, driving a third-party application. A Mac project remains possible with an adapted scope, stated clearly in the quotation.

What happens if Excel or the API changes?

Since the code is with you and commented, nothing seizes up overnight. For outside connections, the API address and version are isolated in a settings sheet, which lets you correct them without touching the code. An update can be ordered by the half-day, with no compulsory maintenance contract.

Can an existing ribbon be extended, or DossiersLocaux?

Yes, both ways: adding buttons to a workbook you already own, or starting from DossiersLocaux and lifting the 7-external-tool limit to graft your own functions onto it. Taking over an existing file is often cheaper than starting from scratch.

How long really, between the first call and actual use?

Allow 48 hours for the quotation, then 2 to 6 weeks of development depending on scale, with intermediate deliveries: the first buttons are usually usable after ten days.

Describe your most painful gesture

The one you redo every week, in twelve operations. It is almost always the one that turns into a single button.

Request a free quotation

✉️ Answer within 48 working hours · Detailed quotation, item by item · No commitment before written acceptance