cytop .

  • Member since Sep 1st 2010
  • Last Activity:
Posts
10,876
Likes Received
3
Points
32,793
Trophies
1
Profile Hits
6,163
  • 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

    Worksheet

    Workbook

    Application

    End Enum


    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.


    awsmitty