Conclusions/ Summary
Files from Command windows compared to Device Manager Properties
We modify the macro from here,
http://www.excelfox.com/forum/showth...ll=1#post12347 ,
, to this
http://www.excelfox.com/forum/showth...ll=1#post12349
, and then re run on the worksheet with the now coloured found files. The modification is
_ a) changing from a VBA “array” type code to a “spreadsheet” type code, which in turn allows us to
_ b) check for cell text colouring, and so allow noting the number of files in any type which were also to be found in the list made from the Device Manager Properties
We then have the following in the Immediate Window, on running Private Sub FileTypesHereArrays()
sys 1 (1)
dll 15 (8)
bin 3 (1)
cpa 1 (1)
vp 5 (5)
els 4
bag 1 (0)
xml 11 (0)
js 3 (0)
gdl 1 (0)
cab 1 (0)
ini 3 (0)
cat 4 (0)
inf 4 (0)
pnf 4 (0)
gpd 3 (0)
exe 1 (0)
In total only 16 files of the 61 in the list from Command prompt are in the list obtained from the Device manager properties. These are all to do with the Grafikkarten. They comprise 16 of the 21 files from the list obtained from the Device manager Grafikkarten properties
_____ Workbook: ExplorerBefore cmd V DeviceManager.xlsm ( Using Excel 2007 32 bit )
Worksheet: DeviceManagerProperties
Grafikkarten Intel(R) G41 Express Chipset (Microsoft Corporation - WDDM 1.1) C:\Windows\system32\DRIVERS\igdkmd64.sys C:\Windows\system32\igcompkmg500.bin C:\Windows\system32\igd10umd64.dll C:\Windows\system32\igdumd64.dll C:\Windows\system32\igfcg500m.bin C:\Windows\system32\igkmg500.bin C:\Windows\system32\iglhcp64.dll C:\Windows\system32\iglhsip64.dll C:\Windows\system32\iglhxa64.cpa C:\Windows\system32\iglhxa64.vp C:\Windows\system32\iglhxc64.vp C:\Windows\system32\iglhxg64.vp C:\Windows\system32\iglhxo64.vp C:\Windows\system32\iglhxs64.vp C:\Windows\SysWow64\igcompkmg500.bin C:\Windows\SysWow64\igd10umd32.dll C:\Windows\SysWow64\igdumd32.dll C:\Windows\SysWow64\igfcg500m.bin C:\Windows\SysWow64\igkmg500.bin C:\Windows\SysWow64\iglhcp32.dll C:\Windows\SysWow64\iglhsip32.dll




Reply With Quote
Bookmarks