Open workbook Count
Use Workbooks.Count
Hervinder wrote:
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
|