Hi

I am using Excel 2000 vba to create a userform that will get some info and save it to the workbook, once it has finished is there a way to get the actual excel application to close not just the workbook, but still automatically save changes?

i.e.
Workbooks("Name.xls").Close (True)
but for the application not workbook.

Thanks
Jennie