Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default Excel keeps running after closing on server

Have noticed that on a Windows 2000 server when you open Excel and close it
there remains a hidden
process running of Excel. So, this shows under Processes in the Windows task
manager.
This has nil to do with any particular workbook or add-in that I can see as
it happens even when nil had
been opened or loaded in Excel. I know that Excel is not really meant to be
running on a server, but I have
no problems otherwise and I wonder what is causing this and if there could
be a solution.
This is Excel 2003.

I have written a little VB6 .exe that takes care of this:

Sub Main()

Dim oWMI As Object
Dim oProcess As Object

Set oWMI = GetObject("winmgmts:")

For Each oProcess In oWMI.InstancesOf("Win32_Process")
If UCase(oProcess.Name) = "EXCEL.EXE" Then
oProcess.Terminate 0
End If
Next

Set oWMI = Nothing

End Sub


But I would like to solve this at source rather than fixing the symptom.


RBS

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,549
Default Excel keeps running after closing on server


RBS,
This is the only reference I have...
"Considerations for server-side Automation of Office"
http://support.microsoft.com/kb/257757/en-us
(you have probably already seen it)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"RB Smissaert"

wrote in message
Have noticed that on a Windows 2000 server when you open Excel and close it
there remains a hidden
process running of Excel. So, this shows under Processes in the Windows task
manager.
This has nil to do with any particular workbook or add-in that I can see as
it happens even when nil had
been opened or loaded in Excel. I know that Excel is not really meant to be
running on a server, but I have
no problems otherwise and I wonder what is causing this and if there could
be a solution.
This is Excel 2003.
I have written a little VB6 .exe that takes care of this:

Sub Main()
Dim oWMI As Object
Dim oProcess As Object
Set oWMI = GetObject("winmgmts:")
For Each oProcess In oWMI.InstancesOf("Win32_Process")
If UCase(oProcess.Name) = "EXCEL.EXE" Then
oProcess.Terminate 0
End If
Next
Set oWMI = Nothing
End Sub

But I would like to solve this at source rather than fixing the symptom.
RBS

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default Excel keeps running after closing on server

Thanks for that link.
I think I had seen it some years ago, but will go through it again.

RBS


"Jim Cone" wrote in message
...

RBS,
This is the only reference I have...
"Considerations for server-side Automation of Office"
http://support.microsoft.com/kb/257757/en-us
(you have probably already seen it)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"RB Smissaert"

wrote in message
Have noticed that on a Windows 2000 server when you open Excel and close
it
there remains a hidden
process running of Excel. So, this shows under Processes in the Windows
task
manager.
This has nil to do with any particular workbook or add-in that I can see
as
it happens even when nil had
been opened or loaded in Excel. I know that Excel is not really meant to
be
running on a server, but I have
no problems otherwise and I wonder what is causing this and if there could
be a solution.
This is Excel 2003.
I have written a little VB6 .exe that takes care of this:

Sub Main()
Dim oWMI As Object
Dim oProcess As Object
Set oWMI = GetObject("winmgmts:")
For Each oProcess In oWMI.InstancesOf("Win32_Process")
If UCase(oProcess.Name) = "EXCEL.EXE" Then
oProcess.Terminate 0
End If
Next
Set oWMI = Nothing
End Sub

But I would like to solve this at source rather than fixing the symptom.
RBS


Reply
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
running Excel VBA macro from SQL Server Smallweed Excel Programming 0 April 25th 07 10:26 AM
Very urgent help needed: Excel is still running after closing it! hans[_5_] Excel Programming 2 February 3rd 06 02:04 PM
Running Excel with VBA on server and calculate [email protected] Excel Programming 0 August 5th 05 07:44 AM
Prevent running macro upon closing Excel Deneb Excel Programming 2 February 2nd 05 07:07 PM
Running Excel from a Server ibeetb Excel Programming 5 December 7th 03 05:39 PM


All times are GMT +1. The time now is 09:53 AM.

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

About Us

"It's about Microsoft Excel"