Don’t have an account yet? Register yourself now and be a part of our community!
cytop, You have an excellent post here : List all open workbooks in all instances of Excel.. However there's a snag.
The piece of code:
Public Enum ExternalRef
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.