One powerful use of Excel is through Apache POI. Replace VB with the language of your choice, run all your logic and tests in that language, and spit out a spreadsheet at the end of it, all neatly formatted for your end users.