'Video thumbnail for How to Run VBA Macro without opening Excel file?'

How to Run VBA Macro without opening Excel file?

visibility 1K views calendar_month Dec 12, 2021

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.