I have recorded and created a VB script to pull a daily report in VIM analytics, there are around 6 different reports which i need to pull on a daily basis.
Once the script run's it will take me till export to excel and give me the path to save, i need to give the name of the file and save, then it will run automatically for next report again till export to excel. and so on...
Can i get some loop coding, where the script should save all the excel files automatically in a specific folder, instead of asking file names every time.
So, once i run the script it should end after saving all the file.
Attach is the script details
Thanks in advance