Solved: Whos in where?

[khalid79m]

Hi guys i need some help again..

I need something that can look in a folder and give me a list of all the xls.files that are in use and also the netwrok id of the person in it.. I need this so I can ring them and tell them to get out...

Thanks :banghead:

[tyndale2045]

This might help you to get started:

http://www.thecodenet.com/articles.php?id=9

Check out the section midway down called "Who has it open?"

[OBP]

This will do the Folder part for you, see this Thread,posts #6 and #13

[CreganTur]

**Post deleted due to sheer stupidity on the poster's part**

[OBP]

Sorry, this is the link, look at the get Directory files Code

http://www.vbaexpress.com/forum/showthread.php?t=23368

[khalid79m]

Thanks for all the help, with the resources I managed to find a soloution