Hi,
Using VB .NET 2003 and the PIA for Office XP.
What I'm basically doing is using Excel as a report generator. I have no problem from VB .NET calling Excel, transferring data from the dataset to the desired range, formatting the spreadsheet, etc. The problem lies that I want the user to have my program open (the VB one) and they run the report which opens Excel, transfers data, etc. and they have the opportunity to view it while Excel is up and can print it from there; but after they close Excel to return to the VB program, the instance of Excel still resides Task Manager.
I don't want to save the file like I saw many solutions that save the file and release the Excel object. I really am just using Excel as a report generator...and if the user wants to save it they can use the File>>Save option from Excel to do that.
I need to know how to monitor Excel from VB .NET and "know" when the user closes that particular instance...and then close out the background process from Task Manager.
Thanks for your help!
Start Free Trial
