By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,098 Members | 1,991 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,098 IT Pros & Developers. It's quick & easy.

List open files in a shared Directory

P: 68
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.
Apr 13 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
What kind of files are you talking about?

Linq ;0)>
Apr 14 '08 #2

Expert Mod 15k+
P: 31,494
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.
Apr 14 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.