Question Excel ActiveX object failed when running VBA via Windows Task Scheduler

If you have an VBA script that is in Excel for example that is set to run or trigger via the Windows Scheduled Tasks and it fails, this VBA script might be trying to automate Outlook emails from Excel, then to get make it work do the following:

Go to Excel Options/Trust Center/Macro Settings and tick the box for 'Trust access to the VBA project object model"

Usually the VBA code works just fine when you run the VBA code manually but fails when the Windows Task Scheduler opens the file which might be set to auto run the VBA script.