Hi everyone. Hopefully this is an easy question to answer:

I want to set an automatic macro to close the file and exit excel.

I also want another one, which prompts the user to save the file an
then close.

Any ideas ?

Thanks
Scott

--
Message posted from http://www.ExcelForum.com

Hi Scott
Sub CloseFileAndExit()
ThisWorkBook.Close(True) 'Or false if you do not wish to save (since you did
not mention)
Application.Quit
End Sub

Sub SaveAndClose()
Do While Application.Dialogs(xlDialogSaveAs).Show = False
Loop
ThisWorkbook.Close
Application.Quit
End Sub

HTH
Cordially
Pascal


"scottwilsonx " a écrit dans
le message de ...
Hi everyone. Hopefully this is an easy question to answer:

I want to set an automatic macro to close the file and exit excel.

I also want another one, which prompts the user to save the file and
then close.

Any ideas ?

Thanks
Scott.


---
Message posted from http://www.ExcelForum.com/

Pascal, thanks for the code you kindly sent thru. Works perfectly!

Much obliged.

Scott

--
Message posted from http://www.ExcelForum.com

Glad it helped

Cordially
Pascal

"scottwilsonx " a écrit dans
le message de ...
Pascal, thanks for the code you kindly sent thru. Works perfectly!

Much obliged.

Scott.


---
Message posted from http://www.ExcelForum.com/