Excel - Excel 2003 + script to open and automatically close an excel workb
Asked By Neil Holden
04-Mar-10 05:46 AM
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.
Microsoft Excel
(1)
Excel 2003
(1)
Workbook
(1)
Macro
(1)
Scheldule
(1)
Workb
(1)
Gord Dibben replied to Neil Holden
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
How do i customize font colors in Excel 2003? Excel How do I customize font colors in Excel 2003? Excel Miscellaneous Discussions Microsoft Excel (1) Excel 2003 (1) Workbook (1) Color (1) Global change (1) Font colors (1) Customize
Reset Excel 2003 Excel I have both Excel 2003 & 2007 on my desktop. I want Excel 2003 to open when I open an excel file but 2007 always overrides 2003. How can I reset Excel Miscellaneous Discussions Microsoft Excel
create an upper and lower control limit in Excel 2003? Excel How do I create an upper and lower control limit in Excel 2003? Excel Charting Discussions Microsoft Excel (1) Excel 2003 (1) Charts (1) Bliengme (1) Jon has lots of examples at http
CONVERT function for Excel 2003 Excel I was trying to format time in decimals to days:hours:mins format. While using microsoft excel 2003 help, they said to use CONVERT funtion for the same. But there isnt any CONVERT funtion in the Inset menu> funtions, in excel 2003. I tried for the same on Excel 2003 installed in other computers as well to
Excel 2007 to Excel 2003 Excel I am running Excel 2007 with Office but I want to have the feel of Excel 2003. Is this possible? Excel Discussions Microsoft Excel (1) Excel 2007 (1) Excel 2003 (1) Office (1) Toolbar (1) Bliengme