Posted to microsoft.public.excel.programming

Jan Karel Pieterse Jan Karel Pieterse is offline

external usenet poster

Posts: 535

Closing Excel within itself

Hi Bruno,

Is it possible to close Excel (not just the workbook) from within a
Workbook_Open event?

Application.quit does the job.

You need to make sure all workbooks are saved or discarded first
though.

Workbooks("Book1.xls").Saved=True sets a workbook to saved state
(without saving).

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Closing workbooks w/o closing Excel	Barb in MD	Excel Discussion (Misc queries)	3	February 15th 10 06:42 PM
Closing Excel	Chad	Excel Discussion (Misc queries)	2	March 18th 05 03:57 PM
Closing VB triggers closing Excel	Minilek	Excel Programming	2	August 6th 04 05:17 PM
closing Excel in VBA	Jeff[_29_]	Excel Programming	1	April 7th 04 08:56 AM
closing excel after closing a workbook	CWalsh[_2_]	Excel Programming	3	January 21st 04 03:33 PM

All times are GMT +1. The time now is 08:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us