EXCEL.exe stays open after Quit method in an HTA
 

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

EXCEL.exe stays open after Quit method in an HTA
 

Hi Myriams9,

Still my Processes show an instance open


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

EXCEL.exe stays open after Quit method in an HTA
 

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

-----Original Message-----
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


.

EXCEL.exe stays open after Quit method in an HTA
 

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?


-----Original Message-----
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

-----Original Message-----
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


.

.

EXCEL.exe stays open after Quit method in an HTA
 

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
-----Original Message-----
Hi Myriams9,

Still my Processes show an instance open


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

.

EXCEL.exe stays open after Quit method in an HTA
 

Oops.

Should be

xlObj.Application.Quit

Kevin Beckham

-----Original Message-----
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?


-----Original Message-----
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

-----Original Message-----
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


.

.

.