Windows 10 and Office Excel

[DocAElstein]

Device Manager Property list against drivers and DriverStore

Device Manager Property list against DriverStore
From Device Manager Properties we have 120 files.
sys 95
dll 13
bin 6
cpa 1
vp 5
els 0
Total 120

It is a reasonable expectation that any matching files from that are found in Device Manager Property in DriverStore may not be those matched in drivers. So initially we will continue using the file from the previous experiments without talking out the text color, add the DriverStore worksheet, and then take it from there

After using this code
http://www.excelfox.com/forum/showth...ll=1#post12406
to make the DriverStore worksheet, it is clear from the large amount of diverse things that some visual inspection is needed to determine how any macro can usefully analyse what we have.

Some initial observations:
Any thing with two underscores in it _ _ appears to be a Folder. This could be used to determine if the thing is a folder. We could also, as ever check, for an entry in column B to determine if we have a folder. Some files have a single underscore.
We have a lot of folders, so it may be safer to use the entry in the column B to determine if folder is present . ( We could also add an extra condition to check that the first three characters are of the "G:" form )

Some file types not yet encountered
inf_loc
HLP
NTF
PPD
TBL
ICC
DAT
dpb
cty
msc
xst

3 funny things
Microsoft.Bluetooth.Legacy.LEEnumerator.sys
Microsoft.Bluetooth.Profiles.HidOverGatt.dll
Microsoft.Bluetooth.AvrcpTransport.sys

The initial VBA arrays macro , although the largest we are likely to use will never the less be made even larger to include the B column, but while I am at it I will top left origin it to the first cell, to keep the “rows” and “columns” in liner with the actual spreadsheet, to help simplify further work.
There are also some redundant parts , such as a section that caught the Folders in he previous use of this macro based on no . in the string
It is not so efficient, but who cares.. , it might help in even further use.

File types in DriverStire
Here is the list produced from the macro here:

sys       389
dll       275
bin       68
cpa       1
vp        5
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 
Total files is  2783
Total Folders is    794

Some notes and conclusions for the file types in DriverStore
To follow maybe…



ExplorerBefore Device Manager Properties V DriverStore.xlsm : https://app.box.com/s/tgd6k3sgs1d0w09dhlizuq8a9asvmu2k