Hi,

I am trying to build a macro that gives me a list of all workbooks that are currently open by another user in a given directory. I want to be able to loop through every file in a given directory (the directory only contains .xlsx files anyway), check to see if it's already open (i.e. in read-only state) and then list the name of it.

Here's what I've come up with so far, but it's giving me some problems:

Please Login or Register  to view this content.

Any help would be appreciated! Thanks.