My latest project was a VB.NET program, which gathers information from different machines in the domain and puts collected data into Excel spreadsheet.
The problem I have is the Excel part. I was able to open new or existing Excel file, place data on multiple worksheets and save it.
I realized, though, that after exiting the program, the EXCEL.EXE *32 process is still running. The funny part of it is that when running program from within the “Visual Studio 2010”, the EXCEL process disappears after program’s completion. I have in my code Marshal.ReleaseComObject calls for each Excel object opened (Excel, workbook(s), worksheet(s)) – but it only works correctly within the VS2010.
Any ideas why it happens?
The problem I have is the Excel part. I was able to open new or existing Excel file, place data on multiple worksheets and save it.
I realized, though, that after exiting the program, the EXCEL.EXE *32 process is still running. The funny part of it is that when running program from within the “Visual Studio 2010”, the EXCEL process disappears after program’s completion. I have in my code Marshal.ReleaseComObject calls for each Excel object opened (Excel, workbook(s), worksheet(s)) – but it only works correctly within the VS2010.
Any ideas why it happens?