Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save and Close all Open Workbooks using VBScript
Hi,
Doea anyone know how to automatically save and close all open workbooks? Thanks, Rick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save and Close all Open Workbooks using VBScript
can be done as under, two options: In 2nd option, Excel is closed.
Sub closing() ThisWorkbook.Activate For Each Window In Application.Windows If Not Window.Index = ActiveWindow.Index Then Window.Close Savechanges:=True End If Next Window ThisWorkbook.Close Savechanges:=True End Sub OR Sub quitting() For Each w In Application.Workbooks w.Save Next w Application.Quit End Sub "Rick De Marco" wrote in message m... Hi, Doea anyone know how to automatically save and close all open workbooks? Thanks, Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to open, Update links, save and close workbooks | Excel Discussion (Misc queries) | |||
Open Close workbooks | Excel Discussion (Misc queries) | |||
Auto open 8 workbooks in different folders, then save on close... | Excel Programming | |||
Excel VBA-How to close all open workbooks except one specific? | Excel Programming | |||
help with macro to open and close workbooks | Excel Programming |