Hi all,
I am brandnew to VBA but learn a bit more every day. Now I have the following problem that needs your help:
I have about 15 different excel inventories and need to check every Monday if changes were made in the last week. All files are shared hence "tracking changes" is basically possible.
Now instead of clicking the mouse so many times I attempted to start recording a macro to ease my work. The result was the following code:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
> </o
>
Sub TrackChanges()
'
' TrackChanges Macro
'
<o
> </o
>
'
With ActiveWorkbook
.HighlightChangesOptions When:="15.03.2010"
.ListChangesOnNewSheet = True
.HighlightChangesOnScreen = True
End With
End Sub
<o
> </o
>
<o
> </o
>
Unfortunately this macro does not really work - nothing happens! What is wrong with this?
<o
> </o
>
PS. At a later stage I want to replace the hard coded date with an input msgbox...
Much appreciate any comment.
Thanks in advance
I am brandnew to VBA but learn a bit more every day. Now I have the following problem that needs your help:
I have about 15 different excel inventories and need to check every Monday if changes were made in the last week. All files are shared hence "tracking changes" is basically possible.
Now instead of clicking the mouse so many times I attempted to start recording a macro to ease my work. The result was the following code:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




Sub TrackChanges()
'
' TrackChanges Macro
'
<o


'
With ActiveWorkbook
.HighlightChangesOptions When:="15.03.2010"
.ListChangesOnNewSheet = True
.HighlightChangesOnScreen = True
End With
End Sub
<o


<o


Unfortunately this macro does not really work - nothing happens! What is wrong with this?
<o


PS. At a later stage I want to replace the hard coded date with an input msgbox...
Much appreciate any comment.
Thanks in advance