cytop .

  • Member since Sep 1st 2010
  • Last Activity:
Posts
10,876
Likes Received
2
Points
32,792
Trophies
1
Profile Hits
4,099
  • 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