从AutoSys运行作业时,出现错误。 VBS运行Excel宏。 VBS代码:
Option Explicit
Dim xlApp, xlBook
Set xlApp = CreateObject("Excel.Application")
On Error Resume Next
set xlBook = xlApp.Workbooks.Open("Z:\Confidential Restricted\Weekly_HR_Employees_Macro.xlsm",0, False)
xlApp.Run "Weekly_HR_Employees_Macro.Weekly_HR_Employees_Macro"
xlBook.Close True
xlApp.Quit
set xlBook = Nothing
Set xlApp = Nothing
错误:
Microsoft VBScript runtime error: ActiveX component can't create object: 'Excel.Application'
CreateObject
语法是错误的。这导致了错误的出现。即使您提供了+1000000000的赏金,除非您更正语法并告诉我们使用正确语法时抛出的错误,否则不可能有其他答案。 - Axel RichterHKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Application
和/或HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Application.15
是否存在? - Axel Richter