Suppose that you have a lot of Excel files (workbooks) currently open. You would like to count the number of these files and also total up the number of worksheets each of these files contains. Write a sub that will perform this task and report the results in a message box.
I understand how to count all workbooks...but how do I count all worksheets within the open workbooks?
Please help, thank you!