Check if network folder in use

[LanceBraun]

With a VBA Macro I'm about to rename a folder and all it's sub-folders (not in that order).
Before I can do that, is there some code that might give a warning: listing users, the file & directory they have open in the tree I'm about to re-name?

An example directory is in the form:
Dir(Root & "\" & Client & "\" & JobNo & " - " & Product & " - " & Client & " \ ")

The path is made up of string variables. Then there are further folders under this particular job.

I'm certainly a novice and any help is appreciated.