Saving all open workbooks
 

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

Saving all open workbooks
 

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

Saving all open workbooks
 

Thank you Ron works great

Greg
"Ron de Bruin" wrote in message
...
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