I have an Excel macro that is used by about 15 people. The macro creates reports for these people and emails them. Email addresses are stored on a worksheet of the macro workbook and if an email address isn't found it asks the user for the information so the macro will update the list.
So here's the problem.... With multiple users accessing this macro, the macro can not always update the list if someone else is using the macro too. If they place a copy of the macro on their desktop, it runs and updates just fine. But if they copy that updated macro back to the network they probably have overwritten somebody eles updates.
I know this must be a common problem but I know almost nothing about networks. Anybody know how this is typically resolved? I was considering maintaining two email lists and comparing them but this seems like it could get quite complicated. I'm not opposed to comparing two lists, I just don't know if that is the best solution.
Ideas anyone?! (and telling 15 users to be patient and take turns didn't work)