how to dispose excel ?????
in the VB program,
i want bring up a excel sheet ( visible = true) and fill in some items, let user to print the excel.
however, i don know how to dispose excel , if i use
...
...
oExcel.Visible = True
...
...
...
oExcel.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(oExcel)
GC.Collect()
then excel sheet flash and close, (that's for sure)
if i don add the last 3 commands, progress EXCEL.exe will stay in memory even after user close the excel sheet.
so , how to make the sheet stay on screen and dispose after user close the excel? anyone can give me some suggestions?