Who is in the spreadsheet?!?!

[dms37]

Hi all,

I'm not even sure if this is possible but it's been annoying me for an age at work. There are numerous spreadsheets on the networked drives where I work and quite often I need to edit some information but the required sheet is locked for editing because a different user is in it. In general this is OK because a lot of people have their MS user details set to their name (in the options settings of Excel, Word and the like).

The problem arises when someone has it set to the default (the company name) and keep it open for long periods.

Basically, is there a way to find the windows user name given by Environ("Username") of a specific document using VBA - or any other method come to that.

Thanks

Dave

 

[id107]

One method I used here, which probably isn't the best one was to have a sheet called "accesslog" which recorded every Environ("Username") within Col A and then saved on entry.

Probably not the best solution, but it proved useful.

 

[dms37]

Yeah. I've done that before for a different problem - unauthorised access. This is more to just show who it is so I can email them and ask them to save and close it so I can get on with what needs doing.

Thanks for the input though, appreciated.

 

[F&s anaylst]

You can setup macro to can auto save and close if not being used at set timeframe ss below for link

http://www.cpearson.com/excel/TimedClose.htm

 

[dms37]

Thanks Kevin. I think that should do the job nicely.

Thanks very much.

Dave