I have a main XLS sheet that I run a VB script and that would produce me a CSV file that is fed into a BI report to show some visualizations.

Question is, How do I make running these VBS scripts automated so when I modify the main sheet, these VBS scripts would automatically run and have my BI report show the latest updates at the next refresh?


Thanks