Here is the script(.vbs) that I' trying to execute to run macro in a specific workbook and I have checked enable macro option in trusted setting. Though I'm getting above error message
Code
'Input Excel File's Full Path
ExcelFilePath = "C:\Users\S_Book4.xlsm"
'Input Module/Macro name within the Excel File
MacroPath = "Module1.Save_PDF"
'Create an instance of Excel
Set ExcelApp = CreateObject("Excel.Application")
'Do you want this Excel instance to be visible?
ExcelApp.Visible = True 'or "False"
'Prevent any App Launch Alerts (ie Update External Links)
ExcelApp.DisplayAlerts = False
'Open Excel File
Set wb = ExcelApp.Workbooks.Open(ExcelFilePath)
'Execute Macro Code
ExcelApp.Application.Run wb.name &"!" & MacroPath
'Save Excel File (if applicable)
wb.Save
'Reset Display Alerts Before Closing
ExcelApp.DisplayAlerts = True
'Close Excel File
wb.Close
'End instance of Excel
ExcelApp.Quit
'Leaves an onscreen message!
MsgBox "Your Automated Task successfully ran at " & TimeValue(Now), vbInformation
Display More