Close a workbook and then MS Excel?

[thepunisher]

Hi,

I am using the following code to save and then close a currently open workbook.

ActiveWorkbook.Save 'Save workbook.
ActiveWorkbook.Close 'Close workbook.

I also want to end the actual MS Excel Application, after the save and close have been done.

how do i do this?

thePunisher

Homer Simpson: Im not a religious man, but Superman, if you're up there, save me!!!

 

[Molby]

application.quit

 

[xlbo]

can't run code from the workbook you are closing after it has been closed so you would need to replace
activeworkbook.close with application.quit

If you are controlling one workbook from the other, then you can do as Molby suggests and tag that line on at the end

Rgds, Geoff

Yesterday it worked. Today it is not working. Windows is like that.

Please read FAQ222-2244 before you ask a question

 

[thepunisher]

Works like a charm.

Do you guys know anything about binary files?

Homer Simpson: Im not a religious man, but Superman, if you're up there, save me!!!

 

[fredericofonseca]

Yes a lot, but that's another thread.

Create a new thread with the all the necessary information and someone will help you.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com