If i move the Save after the HighlightChangesOptions it will popup a
message saying it can only be used when workbook is saved.
The problem is actually not only in python, i figured out that the
samples in msdn (which do the same) don't work in VBA also (if i give
my macros a shortcut).
I have no
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 (xlAllC
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),
