Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save all open workbooks
Hi. Does anyone know of a quick way of Saving all open workbooks without
closing them? I know you can use Shift + File = Close All, but I want to keep all my workbooks open. I look forward to hearing if anyone has a solution. Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save all open workbooks
Vicki, here is one way with a macro,
Sub Save_All_Open_Files() Dim wkbk As Workbook On Error Resume Next For Each wkbk In Workbooks wkbk.Save Next End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Vicki" wrote in message ... Hi. Does anyone know of a quick way of Saving all open workbooks without closing them? I know you can use Shift + File = Close All, but I want to keep all my workbooks open. I look forward to hearing if anyone has a solution. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to save sheets as separate workbooks | Excel Discussion (Misc queries) | |||
cannot open an xl97 file | Excel Discussion (Misc queries) | |||
I need an excel plug in to save workbooks in adobe acrobat format | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
Why when i have more than one workbook open and i want to save ch. | New Users to Excel |