Try this Greg

Sub test()
Dim wb As Workbook
For Each wb In Workbooks
wb.Save
Next wb
Application.Quit
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Greg" wrote in message ...
Hi all,

I am using a userform to look at different workbooks all at once. How do I
get excel to save all the workbooks at once then use the application.quit
option?

Thanks

Greg