[breck]

Have you thought about not having the external components, and moving the logic/code into the spreadsheet itself? In other words, just have a single spreadsheet and the whole UX in that, and the things you have as external components integrate right into the user's sheet. You can have both secondary notations and conditional projectional editors based on the parsing of the sheet.

Example: https://www.youtube.com/watch?v=0l2QWH-iV3k

[davchana]

I cobbled in a spreadsheet, where one page convers numbers to words (10 to Ten) any amount till $1,000,000. No vba. One sheet is database for cheques. One sheet has three pages, each printing a version of cheque on bank cheque leaves. One other prints an electronic cheque. One last one prints complete cheque on blank stock paper.

All of these sheets gets all data from cheque database & bank database.

[2Gkashmiri]

Same thing. I started working on a financial statement excel sheet like 4 years ago, refining it, then standardizing it, then decided to make data entry in a sheet. Then added more stuff.

4 years later I have import data from old file, previous year data import, PDF output, customised displays, multi page PDFs and I am just getting started. Come financial year, this is my most cherished work and I do it all the time. (Staff has to keep up with version updates every next week)

[hypermachine]

We went the other way round and built a VBA interpreter instead.