excel exit

[cole7011]

whats the vb code, for exit excel,

so i could place it at the end of a vb statement and when ran it would close the current open worksheet....

thanks

 

[Norie]

Do you want to totally close Excel or just the active workbook?

Totally close Excel : Application.Quit

Close active workbook: ActiveWorkbook.Close

 

[Smitty]

In addition to what Norie said, Activeworkbook.Close True will save the wb, Activeworkbook.Close False won't.

Hope that helps,

Smitty