How do I stop an EXCEL Process

[Jim]

I have a application written in VB6 that accesses a database and outputs to
EXCEL.
The output ends with "MYexcel.quit" and the relevant prompt displays. If I
exit Excel atthat stage the EXCEL process is left running as seen in
Taskmanager.
Run the program a couple of times and soon the machine grinds to a halt.

So the question is - How do I stop/exit from excel via VB

 

[RB Smissaert]

More than likely this is caused by references that are not set to nothing.
So before doing MYexcel.Quit make sure
that all these references are released.
If I remember welll there also can be a problem with the With End With
construction. If the above fails try to get
rid of this.

RBS

 

[Stephen Bullen]

Hi Jim,

I have a application written in VB6 that accesses a database and outputs to
EXCEL.
The output ends with "MYexcel.quit" and the relevant prompt displays. If I
exit Excel atthat stage the EXCEL process is left running as seen in
Taskmanager.
Run the program a couple of times and soon the machine grinds to a halt.

So the question is - How do I stop/exit from excel via VB

My guess is that somewhere in your code, you're not explicitly refering to
your MyExcel object, but using what's normally a 'global' object in Excel
without qualifying it, such as:

Set oRange = oSheet.Range(Cells(1,2), Cells(10,20))

In that case, the Cells() bits aren't qualified. That causes VB to create its
own internal object to reference the Excel application, which often leaves an
Excel process running.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

 

[Tushar Mehta]

As has been pointed out you probably have an unqualified reference to an
XL object. For how to address the problem, see
Program won't quit
http://tushar-mehta.server101.com/excel/vba/xl_doesnt_quit/index.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005