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" <(E-Mail Removed)> wrote in message
> news:2AB45AF3-DEE6-4468-844C-(E-Mail Removed)...
> > 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
> > > >
>
>
>
|
Similar Threads
