Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA Finding who has a file checked out on sharepoint

Thread starter ubengineer
Start date Jan 23, 2015

Status: Not open for further replies.

Jan 23, 2015

ubengineer

Aerospace

On SharePoint a if I try opening an excel file that is already checked out a popup message comes up Titled: "File in Use" Message: xxxxxx.xlsx is locked for editing by 'WORKGROUP\username'. I need a VBA code that will give me this username without opening the file. I found code for checking if the file is closed, read only, or Checked Out all without opening but can not figure out how to get that username. The document is on SharePoint / on a network. Does anyone have any ideas?