I've tried to use the following two portions of code to check what users are in an Excel 2010 workbook. In the first section of code, if I'm the only one in the workbook, it will return me as the user. However, when I'm the exclusive user and there are others in the workbook, the code returns me as the only person in the workbook. Also, when there are others in the workbook and I don't have exclusive access, when the code hits the, "Users = aDataWbk.UserStatus" section of code, I get the error: "Run time error '1004'. Cannot access the read-only document 'Z:\Reporting\IBE Scoreboard2.xlsm'.
In the second section of code, I'm always returned as being the exclusive user of the workbook, regardless of how many people are in the workbook and who has exclusive access. Can anyone tell me what's going on? Please note, I posted this question yesterday morning in the Microsoft Answers forum and have gotten no responses. The link to that post is: http://answers.microsoft.com/en-us/o...a-d5eb2f5ec05d.
Code section 1:
Code section 2:Please Login or Register to view this content.
Any help would be greatly appreciated!!Please Login or Register to view this content.
Brian
Bookmarks