| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close excel in vbe
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close excel in vbe
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close excel in vbe
ThisWorkbook.Save application.quit -- Don Guillett Microsoft MVP Excel SalesAid Software "pls123" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Close excel in vbe
tx all !! "Don Guillett" wrote: ThisWorkbook.Save application.quit -- Don Guillett Microsoft MVP Excel SalesAid Software "pls123" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
| Can I stop the close method in an auto close macro | Excel Programming | |||
| Not close thead when I close excel | Excel Programming | |||
| Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
| excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
Linear Mode
