Automatically run your Excel VBA code using Task Scheduler

Home › Other Content › Automatically run your Excel VBA code using Task Scheduler

Channel: Atanu S • Sourced: Youtube • Published 2 years ago

#shorts
#shortvideo
#shortsvideo VBS code:

Set objExcel CreateObject(/"Excel.Application/")

objExcel.Application.Run /"'C://Users//Atanu Sarkar//Desktop//TestWorkBook.xlsm'!RunMe.Run/"

objExcel.DisplayAlerts False

objExcel.Application.Quit

Set objExcel Nothing

Please take the opportunity to connect and share this video with your friends and family if you find it useful.