OLE-Excel
Hello!
I have found out, that this script leaves a running process named Excel in the Windows Taskmanager:
Variant Excel = CreateOleObject("Excel.Application");
Excel.Visible = true;
String ExcelFile = "d:\Lehrverpflichtung.xls"; // Pfad der ExcelDatei
Excel.Workbooks.Open(ExcelFile);
Variant Sheet = Excel.ActiveWorkbook.ActiveSheet;
Sheet.Cells.Item(1,1).Value = "Hello";
Excel.ActiveWorkbook.Save();
Excel.Workbooks.Close();
Excel.Quit();
The Quit function closes Excel, but in memory there is a Process EXCEL.EXE left.
I suppose, the OleObject is not destroyed, at the end of the Script.
A Bug or a feature?
I have found out, that this script leaves a running process named Excel in the Windows Taskmanager:
Variant Excel = CreateOleObject("Excel.Application");
Excel.Visible = true;
String ExcelFile = "d:\Lehrverpflichtung.xls"; // Pfad der ExcelDatei
Excel.Workbooks.Open(ExcelFile);
Variant Sheet = Excel.ActiveWorkbook.ActiveSheet;
Sheet.Cells.Item(1,1).Value = "Hello";
Excel.ActiveWorkbook.Save();
Excel.Workbooks.Close();
Excel.Quit();
The Quit function closes Excel, but in memory there is a Process EXCEL.EXE left.
I suppose, the OleObject is not destroyed, at the end of the Script.
A Bug or a feature?
Comments
FS leave one "Excel" process per application (independent from how many script you have executed). This process is terminated when you exit your application.