Environment Username Excel Network ID?

[TomYC]

I have numerous Excel files that I have created for shared use in data input. Each user enters data into a different worksheet. There is some possibility that when user B attempts to open the file, he/she will get a read only copy because user A still has the file open. Perhaps user A will quickly finish and user B can proceed.
However, is there a way I can encode an 'on open' vba event such that user B on his read only copy can tell that user A has the file open so he can send an email to 'hurry up?'

 

[1DMF]

Office 2010 has this feature built in apparently, not sure if you have to have OCS as well.

I'm not sure if there is a way to query who has the file open, it shows on the server under open files, but I don't think you can plug into that info from VBA.



"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts