With what in conjunction is it better to use MS Excel as a frontend?

Question

Visual Basic

Good time of the day. Need advice.
In programming, I can do a little, for my main work I work with MS Office, and I use highly specialized software. I wrote an Excel book for the department with VBA macros (I did what I know a little about), the data for which the user enters and stores, and the macro, based on this data, generates several types of acts automatically. Now the question arose about the need for mass integration of new templates (potentially several dozen additional pieces). But in turn, this will lead to a loss of usability. Thus, I see an option - to implement an interface based on Excel, but in what way could information storage be implemented, what would be easier both to implement and to understand it yourself? On the one hand, it can be implemented in Excel files, but I'm afraid that I'll put too much on file macros. If you use Access, then with a cursory reading of the manuals, I did not find an implementation option in which the new value written to the cell would be immediately reflected in the database. And at the moment I don’t understand how to insert rows in a table in Access from Excel with a macro and work with the database in general.
Please send me what to read and what to learn. There are three requirements:
- the implementation must be portable for the user; opened the file and started working.
- this should go for MS Office 2007 and older.
Thanks

Answer 1

Remove Excel completely and rewrite macros in Access.
These users will enter immediately into Access, which will also generate acts.
All visualization - on forms Access.
Access itself was written not just as a database, but as a platform for small applications.

Answer 2

I don’t know about Excel, but Open Office has a mechanism for interacting Excel-type tables with a database. Moreover, the interface is designed for a fairly ordinary user, it does not require any special knowledge and talents.

Answer 3

I recommend learning VSTO - a very convenient technology that allows you to get the full functionality of NET from Office Add-ins.