auto_close macro

Mar 6th, 2002, 05:34 AM

how can i make a auto close macro so that it save all active workbook when closing down?

sub auto_closed
ActiveWorkbook.save
End Sub

i can only make it save 1 active workbook ;/

dk · Mar 6th, 2002, 05:39 AM

You could try something like this:-

Code:

Sub Auto_Close()
Dim wb As Workbook

On Error Resume Next
For Each wb In Excel.Workbooks
    wb.Save
Next

End Sub

HTH,
D

Mar 6th, 2002, 05:39 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	You could try something like this:- Code: Sub Auto_Close() Dim wb As Workbook On Error Resume Next For Each wb In Excel.Workbooks wb.Save Next End Sub HTH, D

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 05:34 AM	#1
Guest Posts: n/a	how can i make a auto close macro so that it save all active workbook when closing down? sub auto_closed ActiveWorkbook.save End Sub i can only make it save 1 active workbook ;/