Closing Workbook & Excel

Need a little help please.

How do I SAVE and CLOSE Workbook and it's instance of Excel.

I have other instances of excel open that I do not want closed.

I thought that I had this before, but I can't find it if I did. I do keep a list of all the requests where I ask for help and it's not in this list.

Hi Launchnet,

I suppose the simplest way is to add

ThisWorkbook.Close savechanges:=True or
ActiveWorkbook.Close savechanges:=True

dude click the X below the X in the top right corner

the top one closes all workbook the next one down will only close that instance of excel

Hello Matt,

This macro will close a workbook that was created in a separate instance of Excel. However, it does not save the workbook. I'll need to do some research on that.

Please Login or Register  to view this content.

Kerno . . . Tried your code. It closes the workbook, but leaves the instance of Excel open. Not good.

Pike . . . I should have mentioned that this is for at the end of a macro that is run, and when the macro is finished, the Workbook and the Instance of Excel needs to be closed.

Hi Leith . . . I think I can save the workbook before this macro is run and then call my closing macro. I will try it, but I don't have time tonight. Just got home and I will try it late morning. Many thanks. Good hearing from you.

sorry about that reply I kinda knew it would be more ...

How do I make this as solved since it has been over 12 days. It doesn't allow me to edit.