#1   Report Post  
Posted to microsoft.public.excel.programming
TOM TOM is offline
external usenet poster
 
Posts: 6
Default close excel

Hello,

I am using this:

ActiveWorkbook.RunAutoMacros Which:=xlAutoClose
ActiveWorkbook.Close

But Excel after that still open (without workboob). Is there some way how
close Excel completly at the end of macro?

Tom


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default close excel

Hi
use
application.quit
instead of the statements from below

--
Regards
Frank Kabel
Frankfurt, Germany


TOM wrote:
Hello,

I am using this:

ActiveWorkbook.RunAutoMacros Which:=xlAutoClose
ActiveWorkbook.Close

But Excel after that still open (without workboob). Is there some way
how close Excel completly at the end of macro?

Tom


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Why excel close all files when I just want to close one files hon123456 Excel Discussion (Misc queries) 2 December 8th 10 12:12 PM
why do all excel worksheets/workbooks close when I close one? Penny Excel Discussion (Misc queries) 1 November 29th 06 03:49 AM
Excel shoud not close all active books when clicking close button technomike Excel Discussion (Misc queries) 0 June 10th 05 05:35 PM
excel - Windows close button (x) should only close active workboo. CoffeeAdict Setting up and Configuration of Excel 3 February 8th 05 04:30 AM
close excel bris Excel Programming 2 March 4th 04 02:06 PM


All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"