Can you close excel once code is finished?

[jennie]

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

[Leith Ross]

Hello Jennie,

Add Application.Quit below the save workbook statement.

Example:
Workbooks("Name.xls").Close (True)
Application.Quit

Sincerely,
Leith Ross

[jennie]

Thanks for the info:

I couldn't get this to work straight away, but I put application.quit in the workbook_deactivate event and it worked then, was it not working before because the workbook was closing before it got to the application.quit command?

Thanks for the help
Jennie

[Leith Ross]

Hello Jennie,

Glad you caught that. Sorry about the oversight. I meant to include where the code should be placed. Yes, you are correct about why it didn't run this first time.

Thanks,
Leith Ross