Use VBA and python to process data and generate the excel , word, and other kind of files. 1. I can get the data you want from the internet use python. 2. Use python or VBA to preprocess the data. 3. Then use VBA to generate Word document or excel file or ppt files for you as you need.