Hi all,

Driving myself batty with this one.

I'm trying to save a workbook for a shared environment, that will always accept other users changes at all times. I don't want to be prompted, nor do I want my changes to be saved over the top.

Anyway, the MSDN, the VBA help, and even the Properties window in the VBA Editor all make reference to .ConflictResolution.

I quote:
XlSaveConflictResolution can be one of these XlSaveConflictResolution constants.
xlLocalSessionChanges. The local user's changes are always accepted.
xlOtherSessionChanges. The local user's changes are always rejected.
xlUserResolution. A dialog box asks the user to resolve the conflict.
And, from MSDN example (which should do what I want to do)...
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
Please Login or Register  to view this content.
However, if I attempt to set the property myself, e.g. from the properties window, I am given the choice of selecting 3- xlOtherSessionChanges, but when I do it says "Invalid use of Property".

If I run the code sample above, it's set to xlUserResolution (2).

Is there any way for me to set this option, or is this code that has made it into every bit of documentation available, but never made it into the program itself.

Cheers,

Bob