Is there a function for closing Excel using VB?

[Guest]

I have created a macro that saves the current worksheet to a specified
location with a specified name and then closes the worksheet. I would like
to be able to close the Excel application itself from the macro.

Can anyone tell me how?

 

[Dave Patrick]

Application.Quit

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I have created a macro that saves the current worksheet to a specified
| location with a specified name and then closes the worksheet. I would
like
| to be able to close the Excel application itself from the macro.
|
| Can anyone tell me how?

 

[Guest]

Thanks Dave.

Funny thing is that Application.Quit does not work if it is preceeded by
ActiveWorkbook.Close

 

[Dave Patrick]

Once the workbook is closed the code that is/was running terminates. You
shouldn't need that line.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Thanks Dave.
|
| Funny thing is that Application.Quit does not work if it is preceeded by
| ActiveWorkbook.Close