Test if Excel has a file open

[djblois1]

I have some code that will run if someone hits a button. The issue is it will work correctly no matter what file someone has open in Excel, even if it is blank. However, if someone hits the button and no workbook is open then it crashes. Can I test to make sure that a(any) workbook is open?

Here is a screen shot to give people an idea of what I want to testExcel.jpg

As you can see Excel is open but there is no Workbook open. I want to test to make sure any workbook is open.

[Bishonen]

Please Login or Register  to view this content.

but then again, workbooks count is always >0 since personal.xls counts as one.