Best method of comparing changes to directories or hives

[westconn1]

i can can easily compare for added or changed values,
loop through newer list and match against the previous, but while this shows items added, it does not show items removed,

is there a better solution to having to loop through the older list as well to find removed items?

[Spoo]

Pete

Wouldn't removed items appear in the Recycle Bin?

Not sure how that would help, though, since looping
through that list would be equivalent to (or worse than)
looping through your "older list".

Spoo

[westconn1]

Wouldn't removed items appear in the Recycle Bin?

certainly no guarantee of that, files deleted by code do not go to recycle

[Spoo]

Pete

Fair enough.

Pehaps we can then agree, at least, that your OP was
somewhat ambiguous. Could you possibly elaborate?

What is the series of events ...

• When is the "previous" list created?
• When is the "newer" list created?
• What transpires during the interim?
• How are directories added, changed, or deleted ?
  
  • By code only
  • By code and manually?
  • Other?

Spoo

[westconn1]

When is the "previous" list created?
at any time, when required, or may be a current directory, not a list

When is the "newer" list created?
probably just before comparing results, but may just be some other current directory

What transpires during the interim?
whatever, or nothing

How are directories added, changed, or deleted ?
by install, uninstall, manual or code add or delete, effect of someother program, or anything i have not yet thought of

same question as regarding comparing registry keys

[Doogle]

The only thing I can think of is that as you go through the new list you delete matching and changed entries from the old list. What's left in the old list at the end are those items that do not appear in the new list. Saves a complete second pass of the old list. I guess you could use a couple of collections to hold the lists, because it's easy to remove items (perhaps?)

EDIT: Another way is to sort both lists and compare the values to each other.

I=0;J=0
Start Loop:
compare List1(I) to List2(J)
if equal then both appear in both lists, inrcement I and J;
if List1(I) < List2(J) then item is in List2 not List1, increment I,
if List1(I) > List2(J) then item is in List1 not in List2, increment J.
Loop until either I > ubound(List1) or J > ubound(List2).

Then loop through items I to ubound(List1) to show any additional items in List1 that were not in List2. (This caters for List1 having more entries after List2 has been exhausted)
Then loop through items J to ubound(List2) to show any additional items in List2 that were not in List1. (This caters for List2 having more entries after List1 has been exhausted)

If both lists have the same number of entries then neither loop will run. Otherwise one (and only one) of them will.

On second thoughts, it may be easier to show the code:

Option Explicit
Private strList1(9) As String
Private strList2(12) As String

Private Sub Command_Click()
Dim intL1 As Integer
Dim intL2 As Integer
Dim intI As Integer
Do
    Select Case strList1(intL1) - strList2(intL2)
        Case Is = 0
            Debug.Print strList1(intL1); " is in both lists "; strList2(intL2)
            intL1 = intL1 + 1
            intL2 = intL2 + 1
        Case Is < 0
            Debug.Print strList1(intL1); " is in list1 but not in list2"
            intL1 = intL1 + 1
        Case Is > 0
            Debug.Print strList2(intL2); " is in list2 but not list1"
            intL2 = intL2 + 1
    End Select
Loop Until intL1 > UBound(strList1) Or intL2 > UBound(strList2)
For intI = intL1 To UBound(strList1)
    Debug.Print strList1(intI); " is in list1 but not list2"
Next intI
For intI = intL2 To UBound(strList2)
    Debug.Print strList2(intI); " is in list2 but not in list1"
Next intI
End Sub

Private Sub Form_Load()
Dim intI As Integer
For intI = 0 To 9
    strList1(intI) = intI
Next intI
strList2(0) = 0
strList2(1) = 1
For intI = 2 To 12
    strList2(intI) = intI + 1
Next intI
End Sub

(If you don't count the sort, each list is only parsed once)

I used numbers for values and Select Case 'cause it was easier to demonstrate the logic. I'm sure you can adapt as necessary to suit your requirements. (Obviously, both lists have to be sorted in the same order)

Takes me back to the old Mainframe Days of Updating data on 2400ft. Mag. Tapes in Batch so it may be a bit rusty and full of cobwebs, but hopefully, by now, the Spiders should have eaten most of the bugs