Excel and TrackChanges

[Gerard Flanagan]

pierre_py wrote:
> I have a problem with pycom automation with excel.
> If i use the following in my excel_wrapper:
> """
> self.Workbook.Save()
> self.Workbook.HighlightChangesOptions(When=1)
> self.Workbook.ListChangesOnNewSheet = True
> """
> I don't get any history worksheet. If i use 2 (xlAllChanges) or 3
> (xlNotYetReviewed), i get the history worksheet but with all results.
>
> I use Office 2k sp1.
>
> thanks in advance

What does '1' represent?  The first hit in Google for
"HighlightChangesOptions" suggests it may be 'xlSinceMyLastSave', so
maybe there are no changes to show? What happens if you comment out
"self.Workbook.Save()", or move it to below the other two lines?

Gerard