Use Workbooks.Count, but be aware it will count Personal.xls if you have
one, and any other files in XLStart that get opened automatically.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Hervinder" wrote in message
...

I am trying to write a simple code within an existing macro that tells me
how many workbooks are open at any one time.

I can do counting sheets which would be

shts = activeworkbook.sheets.count

i cant seem to apply the same principle with open workbooks.

thank you
hervinder