1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
Sub Test()
Dim TonFolder As String, TonFichier As String
TonFolder = "D;\dossierpartage\"
TonFichier = "fichierxls.xlsm"
MsgBox "Le fichier est deja ouvert par " & GetFileOwner(TonFolder, TonFichier) & "."
End Sub
Function GetFileOwner(fileDir As String, fileName As String) As String
'On Error Resume Next
Dim secUtil As Object
Dim secDesc As Object
Set secUtil = CreateObject("ADsSecurityUtility")
Set secDesc = secUtil.GetSecurityDescriptor(fileDir & fileName, 1, 1)
GetFileOwner = secDesc.owner
End Function |
Partager