I have the following code:

Please Login or Register  to view this content.
This works perfect when saving a read-only file when nobody else has made any changes to the file since you opened it. However, if trying to save the file when somebody else has saved data in the file that your current file DOESN'T have...I get the following prompt:


Prompt.png

I would like to automatically discard the current save and update the open file to the most current data saved.

Is there a way thru VBA to either find these changes and list them for the user or more so, allow me to error handle this prompt within the code and update the current file with the most recent data saved (without the code bombing out like it currently does)?

Thanks!
Thomas