cytop has some excellent code here: List all open workbooks in all instances of Excel.
However there is one snag
The piece of code:
interferes wit any Application function, such as Application.ScreenUpdating = False. I get an error, invalid qualifier, which of course it is. Any suggestions on how to get around this.