Double Driver list against drivers and DriverStore
Double Driver list against DriverStore ( and drivers ]
The previous file, ExplorerBefore Double Driver V drivers.xlsm , will be used further, starting in its current form with no resetting of colouring.
The name is ExplorerBefore Double Driver V DriverStore.xlsm , ( but we will also show finally the Double Driver list against driver ]

In the last section, ( Double Driver list against drivers ( drivers against Double Driver ] ) ) , we considered that the drivers was the smaller of the two things being considered. But if we now look at the two worksheets we see that a Double Driver list against DriverStore comparison is possibly more appropriate

Double Driver
Code:
sys   128 
dll   49 
bin   3 
cpa   1 
vp   5 
els   1 
inf   81 
ini   107 
cat   4 
gpd   29 
xml   27 
gdl   2 
js   3 
dpd   0 
cab   1 
bag   1 
ppd   1 
exe   1 
dpb   4 
 Total 448

DriverStore
Code:
 More than 2 dots   --  Microsoft.Bluetooth.Legacy.LEEnumerator.sys
More than 2 dots   --  Microsoft.Bluetooth.Profiles.HidOverGatt.dll
More than 2 dots   --  Microsoft.Bluetooth.AvrcpTransport.sys
sys       389
dll       275
bin       68
cpa       1
vp       5
Else1     0
bag       20
xml       144
js       8
gdl       35
cab       1
ini       185
cat       45
inf       706
pnf       93
gpd       174
exe       1
sam       0
inf_loc   508
pnf       93
hlp       9
ntf       8
ppd       27
tbl       0
icc       0
dat       6
dpb       12
cty       2
msc       2
xst       1
dll.mui   0
sys.mui   0
Else2     0
Total files is  2783
Total Folders is    794
Total things with more than 2 dots is  3
What to do..
So we proceed in this last main comparison experiment, in a very similar way to that for the comparison of Device Manager properties against Driver Store. We can use almost the same macro as this previous one: http://www.excelfox.com/forum/showth...ll=1#post12409 The main difference is that we loop with each cell in a selection range in the worksheet Double Drivers instead of as previously Device Manager Properties.
So, the purpose of the macro here, , is
_ to go through all cells in a (usually small) user selection in Double drivers.
_ A random color is generated to use in any matched file in both worksheets
_ If a match is found, we
___ check to see if the cell maybe already coloured, ( indicating that it was already matched to drivers) . In this case the randomly produced color will be replaced with that already there.
___ the cell is underlined so as to give something later to indicate the double match.
_ Whether the cell is coloured or not, for the case of the match is found the cell in Double Driver has its text italicised. ( In Driver Store all cells are italicised just to help relate the matching in place )




The following post show the usual sets of measurements



ExplorerBefore Double Driver V DriverStore.xlsm : https://app.box.com/s/h95ny25bwfdg4rvrpgv60oktk28ityqq