Windows 10 and Office Excel

[DocAElstein]

Double Driver list against drivers and DriverStore

Double Driver list against drivers ( drivers against Double Driver )

We will follow a very similar set of measurement as those starting here , http://www.excelfox.com/forum/showth...ge12#post12276
We do a very similar analysis as for Device Manager Property list against drivers and DriverStore

The large before file, now named ExplorerBefore Douible Driver V drivers.xlsm , is the previous file, ExplorerBefore Device Manager Properties V DriverStore.xlsm, with the color taken out in drivers ( and while we are at it, DriverStore also , ( the italics can remain in DriverStore) )

Reminder of drivers
From here, http://www.excelfox.com/forum/showth...ge12#post12276 we saw that in drivers we have

Folder?    de-DE
More than 2 dots   --  Microsoft.Bluetooth.AvrcpTransport.sys.mui
Folder?    DriverData
Folder?    en-US
Folder?    etc
Folder?    hosts
Folder?    networks
Folder?    protocol
Folder?    services
Folder?    UMDF
More than 2 dots   --  Microsoft.Bluetooth.Profiles.HidOverGatt.dll
Folder?    de-DE
More than 2 dots   --  Microsoft.Bluetooth.Profiles.HidOverGatt.dll.mui
Folder?    en-US
Folder?    wd
sys       3
dll       12
bin       0
cpa       0
vp       0
Else1     0
bag       0
xml       0
js       0
gdl       0
cab       0
ini       0
cat       0
inf       0
pnf       0
gpd       0
exe       0
sam       1
dll.mui   10
sys.mui   125
Else2     0
Total files is  151
Total Folders is    12
Total things with more than 2 dots is  3

Reminder of Double Driver ( Full List)
Previously , the Double Driver list was taken as the large in which to find files from a smaller. After this we looked back, as it were, to how much of the contents of Double Driver were in other things that were compared against it.
We can use for convenience the routine of this form on the non colured initial worksheet , and edit the output slightly to remove the (0) entries, since no cells have coloured text

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

The listing suggest it might be more convenient to look for the files in drivers, and attempt to find them in DoubleDriver


The macro here, http://www.excelfox.com/forum/showth...ll=1#post12555 , takes each cell in the selection , and checks for at least one . in it, to indicate a file.
An extra code line, not yet used in the similar macros of this type, removes any of the extra strange .mui in the string to be searched for from drivers
Let FileNmeSrchFor = Replace(CelVl, ".mui", "", 1, 1, vbBinaryCompare)




In the next few post , the usual colouring of matched cell values is shown.





ExplorerBefore Double Driver V drivers.xlsm : https://app.box.com/s/fv502svb5oxs3bg1oevx07is698idxi5