locked
Extracting tracked changes using VBA RRS feed

  • Question

  • Hi,

    I have an Excel 2007 workbook that has Tracked Changes switched on.

    The workbook is about to be replaced with an Access 2007 database which has an audit trail function.

    I've extracted the data from Excel and loaded it into Access, but it would be useful to extract the tracked changes too and transform/load them into Access. I can't see any properties/methods in Excel to do this.

    Is it possible or not?

    Phil.

    Saturday, October 26, 2013 4:42 PM

Answers

  • an interesting Question.

    Try this based on the help. I may add some value:

    With ActiveWorkbook
        .HighlightChangesOptions _
            When:=xlAllChanges, _
            Who:="Everyone"
        .ListChangesOnNewSheet = True
    End With 
    


    Brian, ProcessIT- Hawke's Bay, New Zealand

    Monday, October 28, 2013 10:06 PM