List all open workbooks in all instances of Excel.

  • As the title says - will find all instances of Excel and list (to the debug window) all workbooks open. Can be very easily extended for other functionality


  • Re: List all open workbooks in all instances of Excel.


    Revised to actually return a reference to an Excel Application, workbook or worksheet based on the App title, workbook name or worksheet tab name.


    See Sub Test for an example.

  • Re: List all open workbooks in all instances of Excel.


    or ?


  • Re: List all open workbooks in all instances of Excel.


    WHAT!!!


    I can't believe my eyes...


    I even walked away, got a cup of tea and looked again...


    But its still there...


    a "For" loop .... from SNB... :thumbup:


    I need to go and lie down... :D

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

  • Re: List all open workbooks in all instances of Excel.


    :spin:

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!