how to close personal.xls -- how to close excel after a macr

jkpd2000 · May 16th, 2002, 08:47 AM

i am running a macro automatically .
how to close excel after completing that macro.

when i am closing , still personal.xls is opened. how to close that.

[ This Message was edited by: jkpd2000 on 2002-05-16 08:19 ]

jkpd2000 · May 16th, 2002, 09:45 AM

have i posted a hard question?

Adiv · May 16th, 2002, 09:51 AM

If you use
Application.Quit

in your code that will shut down Excel. Any open workbooks will be closed. If any of them has been changed and not saved, Excel will prompt you to save or discard the changes for each open workbook.

Just my $0.02

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 08:47 AM	#1
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	i am running a macro automatically . how to close excel after completing that macro. when i am closing , still personal.xls is opened. how to close that. [ This Message was edited by: jkpd2000 on 2002-05-16 08:19 ]

May 16th, 2002, 09:45 AM	#2
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	have i posted a hard question?

May 16th, 2002, 09:51 AM	#3
Adiv New Member Join Date: May 2002 Posts: 7	If you use Application.Quit in your code that will shut down Excel. Any open workbooks will be closed. If any of them has been changed and not saved, Excel will prompt you to save or discard the changes for each open workbook. Just my $0.02