Use VB Script To Run Excel Macro by dudeman · How to use Visual Basic Script to run Excel macro with single click. This technique can be use with Windows Task Scheduler to fully automate the process. Subscript us for more Office related tips! Related PostsHow To Run any VBScript as a Windows ServiceAutomating SharePoint 2010 Backup Using Windows PowerShell.wmvRunning PowerShell Scripts In Task SchedulerVBScript To Combine XLSX Files Into A Single FileVBScript Basics, Part 31 | Internet Explorer – Existing Window (Automation)Backup Files Using Powershell Share