Detecting Open Workbooks

I am using VBA to Open a workbook. However, I do not want to open it if it's already open (closing, re-opening would take 5 min because of file size).

so before I execute

Please Login or Register  to view this content.

I need to determine what workbooks are open... I have no idea how to do this...

Your code functions.

However, it seems to preclude any other actions.

For example, if I wanted to put up a msgbox stating the file was open (and possibly set that workbook as active), I couldn't because the way the code works it would put a msgbox up for each open workbook.

shg you're not forgotten. I got sidetracked with other things. I will get back and test the code soon and let you know how it works for me.

Please Login or Register  to view this content.

It pops up with "oops" no matter if the file is open or not.....

This works for me:

Please Login or Register  to view this content.