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?