Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conflict Resolution not working
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conflict Resolution not working
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 theres a conflict in the shared workbook. ActiveWorkbook.ConflictResolution = xlLocalSessionChanges "Joel Crasto" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conflict Resolution not working
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 / "Joel" wrote: 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 theres a conflict in the shared workbook. ActiveWorkbook.ConflictResolution = xlLocalSessionChanges "Joel Crasto" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conflict Resolution not working
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 "Joel Crasto" wrote in message ... 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 / "Joel" wrote: 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 "Joel Crasto" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conflict Resolution not working
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 "NickHK" wrote: 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 "Joel Crasto" wrote in message ... 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 / "Joel" wrote: 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 "Joel Crasto" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name conflict | Excel Discussion (Misc queries) | |||
Name Conflict | Excel Discussion (Misc queries) | |||
Name Conflict | Excel Discussion (Misc queries) | |||
Conflict | Excel Programming | |||
Name conflict | Excel Programming |