Using Excel vba Macro to be run through Windows Schedule Task
Hello what I would do is create this .VBS file and then use Windows Task Scheduler to execute this vbs file at the desired interval.
Set fso = CreateObject("Scripting.FileSystemObject")
curDir = fso.GetAbsolutePathName(".")
Set myxlApplication = CreateObject("Excel.Application")
myxlApplication.Visible = False
Set myWorkBook = myxlApplication.Workbooks.Open( curDir & "\myTest.xlsm" ) 'Change to the actual workbook that has the Macro
myWorkBook.Application.Run "Module1.HelloWorld" 'Change to the Module and Macro that contains your macro
myxlApplication.Quit
Application.Run Method (Excel)
This example does require Excel to be installed on to the host running the scheduled task. If that host is a Server or a Desktop computer is your choice.
The Windows Task Scheduler should be done as such for the Action portion of the task:
Action: Start a program
Program/script: C:\Windows\SysWOW64\cscript.exe
Add arguments (optional): C:\Path_to_your_vbs\Your.vbs
Start in (optional): C:\Path_to_your_vbs\