I have a vba procedure which i needs to call automatically by using some script.
this is required because excel workbook is dealing with more than 80000 rows and 50 columns data which is too voluminious ( huge in size) .
one instance of this code take roughly 15 mins to proceed and i need to call it repeatdly for a 20 min interval so that every time new data arrives it process new report.
Adding extra code to this file will make this file more heavy to process (system ram is 2 GB)
so i need a script that can open my work book by opening an instance of excel and run the vba proceure inside my workbook. Also i need script in the end to close and save file and excel once vba procedure ran sucessfully.