I use VBA to do everything I need in Excel. Probably would be better to use other languages, but VBA is what I know...