Close excel in vbe

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

ThisWorkbook.Save
application.quit

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"pls123" <(E-Mail Removed)> wrote in message
news:25BAD495-8AE2-41F5-9A2E-(E-Mail Removed)...
> 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

's Computer Specifications

tx all !!

"Don Guillett" wrote:

> ThisWorkbook.Save
> application.quit
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "pls123" <(E-Mail Removed)> wrote in message
> news:25BAD495-8AE2-41F5-9A2E-(E-Mail Removed)...
> > 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
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
error in running workbook.close() func. after close excel from win	Kayıhan	Microsoft C# .NET	0	29th Mar 2009 12:49 AM
Close a Excel Workbook when close a userform in Outlook	lars.oyangen@hamstad.no	Microsoft Outlook VBA Programming	2	8th May 2008 02:54 PM
Excel shoud not close all active books when clicking close button	=?Utf-8?B?dGVjaG5vbWlrZQ==?=	Microsoft Excel Misc	0	10th Jun 2005 05:35 PM
excel - Windows close button (x) should only close active workboo.	=?Utf-8?B?Q29mZmVlQWRpY3Q=?=	Microsoft Excel Setup	3	8th Feb 2005 04:30 AM
Excel 2000 Workbook close button hides instead of close	Steven Robinson	Microsoft Excel Misc	3	13th Aug 2003 11:28 PM