Determine if any other workbook is open?

[cblakley4]

Is there a way to determine if there is any other excel workbook open?

This is what I'm trying to do. I have an auto_open module that does a routine and then exits excel. I was using application.quit, but that closes all of my excel workbooks (I don't want this).

I then tried activeworkbook.close, however if I don't have any other workbooks open, this leave excel up, but without any workbook.

so is there something like:

If "any other workbook open" then
activeworkbook.close
else
application.quit

 

[Firefly2012]

Hi

Perhaps:

If Workbooks.Count>1 Then

 

[cblakley4]

fantastic! Thanks