This example shows them releasing the variables:
http://support.microsoft.com/default...b;en-us;303871
and this one
http://support.microsoft.com/default...b;en-us;303294
and this one
http://support.microsoft.com/default...b;en-us;302094
and here again:
http://support.microsoft.com/default...b;en-us;301982
HOWTO: Automate Microsoft Excel from Visual Basic .NET
but may be this one has the answer:
http://support.microsoft.com/default...b;en-us;317109
PRB: Office Application Does Not Quit After Automation from Visual Studio
..NET Client
--
Regards,
Tom Ogilvy
"Jeff Grundy" wrote in message
...
In vb.6 that works. But in .net the Object Lifetime is
different. I also tried GC.Collect after the
objExcel.Quit.
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/vbcn7/html/vaconFinalizeDestructors.asp
-----Original Message-----
after objExcel.Quit I would have
objWorkbook = Nothing
objWorkbooks = Nothing
objExcel = Nothing
or the .Net equivalent.
--
Regards,
Tom Ogilvy
"Jeff Grundy" wrote in message
...
When I create a Windows Forms Application using
VB.NET2003
and have that application create and save a workbook, I
cannot open the worksheet with Excel until I close the
VB
application.
Steps to reproduce the problem.
1 Create a Windows Forms Application.
2 Add a reference to 'Microsoft Excel 9.0 Object
Library'.
3 Add a command button to Form1 (Button1).
4 Add the following code to the form:
'***Begin Code***
Private Sub Button1_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Button1.Click
Dim objExcel As Excel.Application
Dim objWorkbook As Excel.Workbook
Dim objWorkbooks As Excel.Workbooks
objExcel = New Excel.Application
objWorkbooks = objExcel.Workbooks
objWorkbook = objWorkbooks.Add
objWorkbook.SaveAs("C:\TempWorkbook.xls")
objExcel.Quit()
End Sub
'***End Code***
5 Run the program.
6 Click the button 1 time.
7 In windows explorer double click the file
C:\TempWorkbook.xls. At this point Excel opens but the
grid area does not display correctly.
8 Close excel.
9 Close the VB application by clicking the x button in
the
corner of form1. If you click 'Stop Debugging' in the
IDE
an Excel process will continue to run in Task Manager-
Processes Tab. You need to 'End Process' or rebbot to
get
rid of it.
10 In windows explorer double click the file
C:\TempWorkbook.xls. At this point Excel opens the file
correctly.
.