I essentially had a spreadsheet driven CRM tool that could

Ping an internal data warehouse API Run data validation Generate email templates Send emails via outlook integration

So some of that wasn't FP as it used VBA but all the validation and checks were done using vanilla functions and were therefore functional.

But you're right, until I figured out how abstract and actually program, VBA script was bound to report generation before I started hitting unmaintainable complexity