I've worked in automating office tasks via Microsoft Office VBA for close to 10 years now. I know it's not a really great scalable solution to automate Excel, but for small-to-midsized businesses it's quick and easy, and fairly reliable to create an Excel solution.