Determine If Specified Workbooks Are Open

  • Hi all, long time no see. I've been working foreign and exotic places.


    Here is the macro:


    Now the problem is, in one workbook this works fine if this is the second to ninth save, but in a different workbook (the one I am currently working on), it does not resume next and defaults to an error. Is there any way to see if exists a window with the ("book#") name 1 through 9, and if so, then select it?


    Thanks in advance![hr]*[/hr] Auto Merged Post;[dl]*[/dl]Hi,


    I figured out the answer. See below code:



    Thanks for browsing :)

  • Re: If Exist Window


Participate now!

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