EXCEL.exe stays open after Quit method in an HTA

  • Thread starter Thread starter myriams9
  • Start date Start date
M

myriams9

Im trying to close the Excel.exe that is open in my
Processes .Imm usng JSCRIPt and VBScript,

var ExcelApp =new ActiveXObject ("Excel.Application") ;

....
ExcelApp.Quit();
//ExcelApp = null;
NAR (ExcelApp);

<script lanugae = "VBscript">
Sub NAR( ByVal O)
Set o = Nothing
End Sub

Still my Processes show an instance open

How can I do this? Any help?
Need to save 35 times and can't have 35 instances of
Excel .exe running
 
Hi Myriams9,
Still my Processes show an instance open
Click to expand...

Are all other references using Excel Objects neatly closed and set to
nothing before you execute Excel's Application.Quit and set it's object
to nothing ?

Is there any workbook still open in Excel, waiting for a save changes
prompt to be handled?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
In the scripting environment that I've used, try

Var xlObj

Set xlObj = GetObject("workbookname.xls")
or
Set xlObj = GetObject("", "Excel.Workbook")
then

xlObj.Quit
Set xlObj = Nothing

Kevin Beckham
 
I'll move my code to VBScript
as it seems to behave better. Have no idea how to set the
value to nothing on JSCript
Perhaps undefined?
 
Im using JAvascript and despite teh call to set the
object to Nothing it does not work.
I'll port the script to VBScript direclty adthen Ill see
if I neatly close all objects
Thanks
 
Back
Top