Learn how to run a VBA macro present in a Excel file without opening it manually.
This technique uses a VB script method to create instance of Excel application and then run the macro.
To use this method, you dont have to learn VB script coding.
Get this code from this page: https://officetricks.com/how-schedule-vba-macro-run-daily-automatically-without-opening-excel/
This page also exlains how you can scehdule this VB script, so that the macro is run daily without any manual intervention.