Video thumbnail for How to run VBA Macro Daily Autiomtically without opening Excel file?

How to run VBA Macro Daily Autiomtically without opening Excel file?

Dec 12, 2021
Learn how to run a vba macro daily without opening the file. Schedule the macro using a vb script file and windows build in option. Here are the steps: 1. Excel file with macro (xlsm) My Sample File 1: "E:\AutoRun\Test Macro Run from Other Workbook VBS.xlsm" 2. Write VBScript to execute macro within Excel My Sample File 2: "E:\AutoRun\MacroScheduler.vbs" 3. Test run macro with cscript.exe "C:\Windows\System32\cscript.exe" 4. Task Scheduler steps Refer this page for detailed information on each step: https://officetricks.com/how-schedule-vba-macro-run-daily-automatically-without-opening-excel/