I would like to create a macro which works as below but I can't quite see how to do it . . .

• If another Excel workbook is not open, save the active workbook, close it and quit Excel
• If another Excel workbook is open, save the active workbook and close it - leaving the other workbook(s) open.

I know how to do all of this, except how to detect if another Excel workbook is open.


Thanks for any help

OK, I solved this myself using Application.WORKBOOKS.Count