Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.vb.ole.automation,microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming,microsoft.public.office.developer.automation
|
|||
|
|||
![]()
Several messages to microsoft newsgroups have been posted regarding excel's
persistence until a program is shut down, but there seems to be no answer. KB article Q317109 http://support.microsoft.com/default...b;en-us;317109 seems to not work? This question seems to be unanswered for VB net. I don't have vb net. Programming with Visual Basic 6, the same behaviour is easily reproduced - excel in the running processes list that won't go away. try this: '--------------------------------------- Dim oXLApp As Excel.Application Dim oXLWb As Excel.Workbook Dim oXLWs As Excel.Worksheet Set oXLApp = New Excel.Application oXLApp.DisplayAlerts = False Set oXLWb = oXLApp.Workbooks.Add oXLWb.Worksheets.Worksheets(1).Name = "my sheet" Set oXLWs = oXLWb.Worksheets("my sheet") '-- insert some data to excel oXLApp.Quit '// the above statement optional whether to close the instance of excel, leave it open, save it prior in VB, whatever. Set oXLWs = Nothing Set oXLWb = Nothing Set oXLApp = Nothing '------------------------------ The excel object will stay in the process list no matter what combination of the above is entered until the calling program is shut down. KB Q317109 says this is by design. ahhhhhhhhhhh. Help please. I want to get rid of excel without my users shutting down the program. |