Is there a function for closing Excel using VB?
 

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?

Is there a function for closing Excel using VB?
 

Application.Quit

--
Regards,

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

"Norm" wrote:
|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?

Is there a function for closing Excel using VB?
 

Thanks Dave.

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



"Dave Patrick" wrote:

Application.Quit

--
Regards,

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

"Norm" wrote:
|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?

Is there a function for closing Excel using VB?
 

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

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