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
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