OK, so I thought I was being smart by using the navigate method of the microsoft web browser Active X Object. My problem is that when the user closes the form, I don't have any control over the document in the browser. This is so because the type of document is detected as a system.__COMObject.
Unfortunately I am useing VB.net 1.0, and don't know of any options from this point. I believe I might be able to marshall it and kill the document using Marshal.ReleaseComObject. I still have to try this, but I don't think this will work.
I fear that this could leave a residual Excel Application Open in the task manager, and possibly even the last open document. As I recall you would have to marshall each individual part of the application (Workbook, Worksheet, etc), and then call the garbage collector.
I will experiment with just trying to use the before mentioned, but if anyone has another solution for displaying the excel document in a window, please let me know.
Unfortunately I am useing VB.net 1.0, and don't know of any options from this point. I believe I might be able to marshall it and kill the document using Marshal.ReleaseComObject. I still have to try this, but I don't think this will work.
I fear that this could leave a residual Excel Application Open in the task manager, and possibly even the last open document. As I recall you would have to marshall each individual part of the application (Workbook, Worksheet, etc), and then call the garbage collector.
I will experiment with just trying to use the before mentioned, but if anyone has another solution for displaying the excel document in a window, please let me know.
