Close excel in vbe
 

hello all !!
im using this..

ThisWorkbook.Save
ThisWorkbook.Close

....to save and close my page at a indicated time..
...but the page of excel remains open..
...and i want to close it too..
how can i do it ??
tx all

Close excel in vbe
 

Application.Quit

If you have unsaved workbooks, Excel will ask you if you want to save them.
To avoid this message, you can add the lines below, or you can save the
workbooks ahead of time and then quit.

Application.DisplayAlerts = False
Application.Quit

HTH,

Eric


"pls123" wrote:

hello all !!
im using this..

ThisWorkbook.Save
ThisWorkbook.Close

...to save and close my page at a indicated time..
..but the page of excel remains open..
..and i want to close it too..
how can i do it ??
tx all

Close excel in vbe
 

ThisWorkbook.Save
application.quit

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pls123" wrote in message
...
hello all !!
im using this..

ThisWorkbook.Save
ThisWorkbook.Close

...to save and close my page at a indicated time..
..but the page of excel remains open..
..and i want to close it too..
how can i do it ??
tx all

Close excel in vbe
 

tx all !!

"Don Guillett" wrote:

ThisWorkbook.Save
application.quit

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pls123" wrote in message
...
hello all !!
im using this..

ThisWorkbook.Save
ThisWorkbook.Close

...to save and close my page at a indicated time..
..but the page of excel remains open..
..and i want to close it too..
how can i do it ??
tx all