Hi there,
Using VBA is there anyway that i can automatically resolve conflict errors?
Ideally, the routine would move the changes user2 (the user who gets the resolve conflicts error dialogue) makes to the next free line and then then accepts the change made by user1.
Can this be done?
Thanks,
Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
But thats nothing compared to the horrors that lurk beneath The Trap Door.
Sad message to you:
DO NOT SHARE WORKBOOKS.
(Yes, I am deliberately shouting here)
Excel is not fit for shared editing of information. The last user saving always wins.
You risk loss of data (as you've already experienced), but worse: wrong data and even corruption of your file (i.e. complete loss of data).
Posting Permissions
Reply With Quote