Below are my experience with VBA:
1. Integration with Outlook, Word
2. Integration with database like Oracle, Mysql
3. Integration with IE to scrap/fill data from/into website
4. Excel consolidation like merging multi files into one base on some rules, convert input txt files into particular output format excel file
5. Excel pivot table/chart automation, shapes automation