LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.vb.ole.automation,microsoft.public.dotnet.languages.vb,microsoft.public.excel.programming,microsoft.public.office.developer.automation
external usenet poster
 
Posts: 1
Default Q317109

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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"