Dienstag, 24. April 2012 13:02
I'm using SOAP in Excel VBA macros to access sharepoint webservices. In the sharepoint site I have a user group which has the names of users who need to have to access to open the excel file. While opening the excel file I'm checking the current user name with the User Group in sharepoint to check the existence of the current user. If the user is present in the sharepoint group then He/She will be able to open the excel file. Otherwise he will get a error message "You Are Not Authorized" as per the macro code I wrote.
As I have "Full Control" permission to the site, I am able to run the excel file without any errors. Also I tested by removing my name only from the group(not removing the "Full Control" permission) I'm getting the above mentioned error message. However when I tried to open the excel file from my collegue's machine, he is getting the following error from the sharepoint, not the other error mentioned above..
"Attachment: Maximum retry on the connection exceeded"
This is due to the group setting option called "Specify who has permission to see the list of group members and who has permission to add and remove members from the group" is set to "Group Members Only". When I change this option to "Everyone" my collegue is able to open the excel file.
Can anybody tell me any solution/workaround for this?
Thanks in advance
- Bearbeitet smartncute Dienstag, 24. April 2012 13:05
Mittwoch, 9. Mai 2012 16:01
to access the userinfo like group membership etc. you need admin level access to do the same.
my suggestion in this case would be to importionate your request for validating the group by passing network credential of user who has full control access.
and runs the rest of code using credentials of the logged in user
Best Regards, Ashutosh | SharePoint World