Find out who has file checked out on Sharepoint

[primagic]

I have the code which checks if the file has been checked out on Sharepoint. Is there anyway of finding out who has the file checked out using VBA (Excel).

Thanks

 

[SkipVought]

Hi,

What code? Please post.

 

[primagic]

If Workbooks.CanCheckOut(xlFile) = True Then
Workbooks.CheckOut xlFile

'...code here does stuff

'Save Workbook
ActiveWorkbook.Save

'Check In Workbook back to sharepoint
ActiveWorkbook.CheckIn

Else

MsgBox ("The file is currently in use. You are unable to check out this document at this time. Please try again later"), vbInformation, "File already checked out"
End If
    End With
    Exit Sub

 

[SkipVought]

Doesn't appear that there is a property that identifies who has checked out.

 

[primagic]

Yes I know. That is my question. Can we find out who checked out the file? What is the syntax?

 

[Telecomgirl08]

I came across this blog post that seems to have a property that identifies who the file was checked out by and user name, maybe give this a try?

http://www.topsharepoint.com/list-all-checked-out-items-using-powershell

Amanda Long
Web specialist

http://www.atlasphones.com/

http://www.phonesysteminfo.com/