test.vbs
文件包含以下代码段..
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("C:\testing\new1.xlsm")
objExcel.Application.Visible = True
objExcel.DisplayAlerts = False
Set Sheeet1 = objWorkbook.Worksheets(1)
'The above script is working when I execute manually via command prompt
Sheeet1.Activate
Sheeet1.TextBox1.value = "C:\testing\"
objWorkbook.Save
objExcel.Application.Run "Execute Calculator"
objWorkbook.Save
objWorkbook.Close
objExcel.Quit
Set Sheeet1 = Nothing
Set objWorkbook = Nothing
Set objExcel = Nothing
当我双击 test.vbs
文件时,上面的代码段工作正常 . 但它没有运行/等待无限时间没有任何错误或Java Executor线程警告 .
软件配置:
-
Excel 2013
-
Windows 7操作系统
以上脚本适用于Windows 10和Excel 2016版本 .
问题是,PC中是否需要更改安全设置?任何人都可以提供解决方案,谁遇到这个问题?