Get name of user with excel file open

• Kev

  Default port

  Points: 1435

  More actions

  November 17, 2014 at 6:13 pm

  #397651

  Hi,

  Is it possible to get the name of the user that has an excel file open.

  At present I have a file open test that can report if the excel file is open before the Excel connection manager tries to access the file.

  I would like to get the name of the user that has the file open.

  Is this possible ?

  Kevin

• Lowell

  SSC Guru

  Points: 323518

  More actions

  November 17, 2014 at 7:46 pm

  #1759137

  i've used Process Explorer from sysinternals in the past

  , as well as OpenedFilesView

  http://technet.microsoft.com/en-us/sysinternals/bb795533.aspx

  http://www.portablefreeware.com/?id=1030

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!