Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 163
Default Excel 2003 + script to open and automatically close an excel workb

Hi, i have a scheldule to run at a certain time, the excel sheet will open,
run a macro and automatically close. The trouble i'm having is the workbook
keeps staying open and not fully closing. Is they a better way to do this?

Help would be greatly appreciated.

Neil.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Excel 2003 + script to open and automatically close an excel workb

"Not fully closing" means what?

Is it "partially closing"?

What remains after the partial close?

Do you want Excel to close also?

Application.Quit will close Excel.

Post your code.


Gord Dibben MS Excel MVP

On Thu, 4 Mar 2010 02:46:01 -0800, Neil Holden
wrote:

Hi, i have a scheldule to run at a certain time, the excel sheet will open,
run a macro and automatically close. The trouble i'm having is the workbook
keeps staying open and not fully closing. Is they a better way to do this?

Help would be greatly appreciated.

Neil.


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
Open, update and convert 2007--2003 then close without any prompt jkeogh Excel Discussion (Misc queries) 0 October 14th 08 05:13 PM
Saving Excel 2003 Workbook in Excel 07 - Error Msg on Script obj WL Excel Discussion (Misc queries) 0 January 15th 08 06:20 PM
Trying to convert a excel 2003 to 2007, but it contain script. Feejo Excel Discussion (Misc queries) 3 January 2nd 08 01:19 PM
Trying to convert a excel 2003 to 2007, but it contain script. Feejo New Users to Excel 2 December 31st 07 07:08 PM
Excel doesn't close Book1 when i open another Excel File panmusic Excel Discussion (Misc queries) 1 April 25th 07 01:52 PM


All times are GMT +1. The time now is 10:06 PM.

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

About Us

"It's about Microsoft Excel"