I believe the foregoing are compelling justifications for choosing Excel Visual Basic over Visual Basic.
A DIFFERENT Type Of Automation. The approach to spreadsheet automation that I refer to, is one that seeks to provide functional spreadsheet automation alternatives for ANY spreadsheet user task(s). Typically, solutions like this would require the developer to study existing manual data recording, analysis and report generation systems, then plan _ in consultation with users _ for incorporation of automation into the spreadsheet to replace them, where possible.
A person with proven competence in this area CAN become "notorious" for developing spreadsheet applications, which eliminate drudgery from the process of using MS Excel to handle large amounts of data. Typically, work that takes hours or days will suddenly take minutes or seconds to finish.
One Possible Application: Plotting a pie chart based on income contributions from all your products and services(daily, weekly or monthly), and reviewing the automatically computed percentages/visual pie slices, can give very illuminating insight.