Conflict Resolution not working

[Guest]

Hi,

Could anyone help me with the option xlOtherSessionChanges.
I tried whatever options I could think of but could not find a solution.

I initially used the following syntax
"ActiveWorkbook.ConflictResolution = xlOtherSessionChanges"
but this gives me a run time error - 1004, method conflict resolution of
the object workbook failed.

Presently I am using "ActiveWorkbook.ConflictResolution = xlUserResolution"
but this requires me to trust the users to choose "Accept others changes"
whenever there is a conflict.

Could anyone suggest a solution or did Microsoft just forget to enable this
function.

Thanks in advance
Joel

 

[Guest]

Below is the VBA help. I you right click the VBA window and select object
browser. the in the search box put in ConflictResolution you will find the
options you are looking for are part of XlSaveConflictResolution




ConflictResolution Property
See Also Applies To Example Specifics
Returns or sets the way conflicts are to be resolved whenever a shared
workbook is updated. Read/write XlSaveConflictResolution.

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.

expression.ConflictResolution

expression Required. An expression that returns one of the objects in the
Applies To list.

Example
This example causes the local user's changes to be accepted whenever there’s
a conflict in the shared workbook.

ActiveWorkbook.ConflictResolution = xlLocalSessionChanges

 

[Guest]

Hi Joel

Thanks for the reply but unfortunately it either doesn't work or I have not
understood what you are trying to convey.

I am able to set conflict resolution to options 1 and 2 (Local Changes and
User Resolution respectively) but I alway get an error (Runtime 1004) when
trying to set it to 3 (Other session changes)

Kind regards
Joel
/

 

[NickHK]

I normally avoid shared WBs, but recording a macro of the Sharing process,
XL2002 gives me this:

With ActiveWorkbook
.ConflictResolution = xlLocalSessionChanges
.KeepChangeHistory = True
.ChangeHistoryDuration = 30
End With

As such, I see no way to set xlOtherSessionChanges manually.
Maybe, whilst Help and the Type Library obviously have this option included,
MS forgot to actually implement it in Excel.
I cannot get that setting to execute without error.
Maybe it is only used in .SaveAs ?

NickHK

 

[Guest]

Hi Nick,

Thanks for the reply.
I had tried the option with 'Saveas' but that too didn't function - it sets
the option to 2 (Local session changes) instead of the requried 3 (Other
session changes).

Do you happen to know, if and how, could we get Microsoft to patch this up?

Regards
Joel