Closing Excel Application VBA

[sassriverrat]

I can easily close Excel just using an application.quit and I could close the individual workbook with the workbook.close

HOWEVER, I'd like for excel to close the current workbook if other workbooks are open and I'd like it to close the entire program if my workbook is the ONLY one open (so it doesn't kill other workbooks if another user has stuff open)..

Ideas?

thanks

 

[KolGuyXcel]

An if condition around workbooks.count>1 should do.

 

[sassriverrat]

An if condition around workbooks.count>1 should do.

thanks!

I don't know why I didn't think of that before, especially considering how much I like to use ifs