List open files in a shared Directory

[Trevor2007]

I would like to list files in a shared directory that are currently open (beeing viewed by other users)
thanks for helping
the shared Dir is going to be pased as a variable.

[missinglinq]

What kind of files are you talking about?

Linq ;0)>

[NeoPa]

Two points.

1. Please don't simply set an assignment to be completed.
   To ask a question you should always show what you've got so far and where you've struggled.
2. I think you will need to look at O/S facilities for this.
   This is not something available as standard.
   
   It may be possible to find a list of files and determine if there are any outstanding locks by attempting to open them each exclusively, but I doubt this will suit your needs. It's a bit of a kludge.

I suggest you ask in Windows if there's an appropriate API (and possibly some assistance in linking in and using whichever API libraries are required from VBA.