I have windows vista and xls 2010. I will send to our users Xls file where a macro extract data from another xls file that I have it on a server shared folder.

(1) What is the maximum number of users who can at the same time access the xls file that I have on the server shared folder?

(2) In the login script, I am using IPconfig to read the IP address of the user machine to direct him to the nearest server. How can I do this inside the xls macro?

I appreciate your help. Thank you.