我正在尝试使用Windows服务启动名为 sample.vbs
的VBScript,但我无法't do that. When I open Task Manager I can see Microsoft ® Windows Based Script Host opened, Excel opened, but that',之后没有任何反应 .
当我使用Console应用程序时,一切都很完美 .
这是我的vbs文件:
SET objExcelApp = CREATEOBJECT("Excel.Application")
WITH objExcelApp
.DefaultSaveFormat = xlWorkbookNormal
.DisplayAlerts = FALSE
.Workbooks.Open "C:\SoftwareARGE\data.xlsx"
.DisplayFullScreen = FALSE
.Visible = FALSE
END WITH
SET objExcelSheet = objExcelApp.Worksheets(1)
objExcelSheet.Cells(1 , 1) = "some data"
objExcelSheet.SaveAs strExcelAppenFile
objExcelApp.Application.Quit
以下是我如何从C#调用vbs:
System.Diagnostics.ProcessStartInfo =
new System.Diagnostics.ProcessStartInfo("cmd", "/c sample.vbs")
{
RedirectStandardOutput = true,
WorkingDirectory = "some path", //actually it's like C:\..
UseShellExecute = false,
CreateNoWindow = true
};
System.Diagnostics.Process proc = new System.Diagnostics.Process()
{
StartInfo = procStartInfo
};
proc.Start();
proc.WaitForExit();// <---- Can't move forward in Windows Service
我不认为问题的原因是Windows服务的权限,因为我以管理员用户身份运行它 .
任何帮助都是极好的 .
最好的问候,OgünADSAY .