I'm doing an automation tool for my team to do the daily report. The report is net worth and income verification, which is kind of standard but still different case by case.
The usual routine for team is first fill in an Excel worksheet, then to write report on Word.
I already made a version of VBA code to transfer numbers and some basic information(key word) from Excel to a Word template with empty table and key words located by content controls and bookmarks.
But some parts in the report require explanation and notations, which are not that standardized. As big as the project goes, I just feel VBA is not a good language to keep developing.