Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS ACCESS VBA Code (Instance of Excel.com sitting in sys tray)

Status
Not open for further replies.

airon

Programmer
Jun 21, 2001
21
US
I am having problems with Excel.exe floating in my Sys Tray.
How can I solve this. It seems like when I run the following code below, somtimes Excel.exe will close out in sys tray, and sometime it will not, causing to get multiple instances of Excel.exe which causes strange things.
What is causing this inconsistency?
Does anyone have any suggestions?

Thanks, Aaron

Dim XlApp As Object
Dim XlObj As New Excel.Application

Set XlApp = XlObj.Workbooks.Open(ExpFilePath & FileName, 0)
XlObj.Visible = True

XlObj.DisplayAlerts = False
XlObj.Quit
Set XlObj = Nothing
 
We have an executable -- "Kill.exe" that does the following:

KILL kills the application specified by a process ID, which can be retrieved from TLIST.
Runs On
Alpha, x86
Files Required for KILL
KILL.EXE
KILL Syntax
kill [-f] {process_ID | pattern}
-f
Forces the process to die.
process_ID
The process ID of the task that is killed. Use TLIST to obtain a valid process ID.
pattern
A complete task name or a regular expression pattern that matches a task name. KILL compares the pattern to task names and window titles.

You can get "Kill.exe" from the Winnt4.0 resource kit. Or just go to google.com and search for "kill.exe" and one of those sites should have a download for you.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top