Check if workbook is the only Excel File Open

Hey all,

I am just wondering if there is a way of checking if the workbook that is currently open is the only one that is open, as I have been asked to make my code exit the application if this is the case rather that just close that one file.

Thanks.

Hello duckboy1981,

Are you referring to workbooks that are all open in the same instance of Excel or in separate instances of Excel or both?

Hi

You can check the Workbooks.Count property to see how many workbooks are currently open in your instance of Excel (and exit if more than 1). Note that this will include hidden workbooks as well (eg Personal.xls) which you may want to account for (g if 2 are open, then is one Personal.xls, if so don't close the wb).

Richard

Hey Leith, thanks for the reply.

Only workbooks in that instance, as any other instance shouldn't be affected by application.quit (I hope!)

Hello Duckboy,

Have a look at Richard's answer.

Sorted, it was picking up 2 open workbooks even if only one, now I know why! Thanks.

Hello duckboy1981,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save