Windows 10 and Office Excel

Printable View

Show 40 post(s) from this thread on one page

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col
C

D

E

212
UMBus-Stamm-Busenumerator

213
C:\Windows\system32\DRIVERS\umbus.sys

214

Worksheet: DeviceManagerProperties

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col
B

C

D

E

3791
G:\Win 10 Devices\Before\DriverStore\FileRepository\umbus.in f_amd64_30be546bea6ffa86 umbus.inf_amd64_30be546bea6ffa86

3792
umbus.inf

3793
umbus.PNF

3794
umbus.sys

Worksheet: DriverStore

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col
C

D

E

215
HID-Tastatur

216
C:\Windows\system32\DRIVERS\kbdclass.sys

217
C:\Windows\system32\DRIVERS\kbdhid.sys

Worksheet: DeviceManagerProperties

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col
B

C

D

E

1307
G:\Win 10 Devices\Before\DriverStore\FileRepository\keyboard .inf_amd64_e085085e52ff47cf keyboard.inf_amd64_e085085e52ff47cf

1308
i8042prt.sys

1309
kbdclass.sys

1310
kbdhid.sys

1311
keyboard.inf

1312
keyboard.PNF

1313

Worksheet: DriverStore

_Row\^Col	C	E
215	HID-Tastatur
216		C:\Windows\system32\DRIVERS\kbdclass.sys
217		C:\Windows\system32\DRIVERS\kbdhid.sys

My China USB stick

My China USB Stick

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col
C

D

E

F

219
USB_China2

220
C:\Windows\system32\DRIVERS\UMDF\WpdFs.dll

221
C:\Windows\system32\drivers\WpdUpFltr.sys

222
C:\Windows\system32\DRIVERS\WUDFRd.sys

223

Worksheet: DeviceManagerProperties

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col
B

C

D

E

4311
G:\Win 10 Devices\Before\DriverStore\FileRepository\wpdfs.in f_amd64_863b4f7bd336d637 wpdfs.inf_amd64_863b4f7bd336d637

4312
WpdFs.dll

4313
wpdfs.inf

4314
wpdfs.PNF

Worksheet: DriverStore

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

USB_China2

C:\Windows\system32\DRIVERS\UMDF\WpdFs.dll

C:\Windows\system32\drivers\WpdUpFltr.sys

C:\Windows\system32\DRIVERS\WUDFRd.sys

Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CB

C:\Windows\system32\drivers\usbhub.sys

C:\Windows\system32\drivers\usbport.sys

C:\Windows\system32\drivers\usbuhci.sys

Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27C9

C:\Windows\system32\drivers\usbhub.sys

C:\Windows\system32\drivers\usbport.sys

C:\Windows\system32\drivers\usbuhci.sys

Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CA

C:\Windows\system32\drivers\usbhub.sys

C:\Windows\system32\drivers\usbport.sys

C:\Windows\system32\drivers\usbuhci.sys

Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27C8

C:\Windows\system32\drivers\usbhub.sys

C:\Windows\system32\drivers\usbport.sys

C:\Windows\system32\drivers\usbuhci.sys

Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CC

C:\Windows\system32\drivers\usbehci.sys

C:\Windows\system32\drivers\usbhub.sys

C:\Windows\system32\drivers\usbport.sys

USB-Massenspeichergeräte

C:\Windows\system32\drivers\USBSTOR.SYS

USB-Root-Hub

C:\Windows\system32\drivers\usbd.sys

C:\Windows\system32\drivers\usbhub.sys

USB-Root-Hub

C:\Windows\system32\drivers\usbd.sys

C:\Windows\system32\drivers\usbhub.sys

USB-Root-Hub

C:\Windows\system32\drivers\usbd.sys

C:\Windows\system32\drivers\usbhub.sys

USB-Root-Hub

C:\Windows\system32\drivers\usbd.sys

C:\Windows\system32\drivers\usbhub.sys

USB-Root-Hub

C:\Windows\system32\drivers\usbd.sys

C:\Windows\system32\drivers\usbhub.sys

USB-Verbundgeräte

C:\Windows\system32\drivers\usbccgp.sys

Worksheet: DeviceManagerProperties

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

G:\Win 10 Devices\Before\DriverStore\FileRepository\tsusbhub .inf_amd64_553447f844bdec99 tsusbhub.inf_amd64_553447f844bdec99

tsusbhub.inf

tsusbhub.sys

G:\Win 10 Devices\Before\DriverStore\FileRepository\tsusbhub .inf_amd64_71bafe46689e1f9c tsusbhub.inf_amd64_71bafe46689e1f9c

tsusbhub.inf

tsusbhub.sys

Worksheet: DriverStore

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col
B

C

D

E

3849
G:\Win 10 Devices\Before\DriverStore\FileRepository\usbport. inf_amd64_6c8d049f5073a198 usbport.inf_amd64_6c8d049f5073a198

3850
usbd.sys

3851
usbehci.sys

3852
usbhub.sys

3853
usbohci.sys

3854
usbport.inf

3855
usbport.PNF

3856
usbport.sys

3857
usbuhci.sys

3858

Worksheet: DriverStore

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col
B

C

D

E

3811
G:\Win 10 Devices\Before\DriverStore\FileRepository\usb.inf_ amd64_3b351e8afee70f3b usb.inf_amd64_3b351e8afee70f3b

3812
usb.inf

3813
usb.PNF

3814
usbccgp.sys

3815

Worksheet: DriverStore

USB Summary

_____ Workbook: ExplorerBefore Device Manager Properties V DriverStore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col
C

D

E

F

219
USB_China2

220
C:\Windows\system32\DRIVERS\UMDF\WpdFs.dll

221
C:\Windows\system32\drivers\WpdUpFltr.sys

222
C:\Windows\system32\DRIVERS\WUDFRd.sys

223

224
Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CB

225
C:\Windows\system32\drivers\usbhub.sys

226
C:\Windows\system32\drivers\usbport.sys

227
C:\Windows\system32\drivers\usbuhci.sys

228
Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27C9

229
C:\Windows\system32\drivers\usbhub.sys

230
C:\Windows\system32\drivers\usbport.sys

231
C:\Windows\system32\drivers\usbuhci.sys

232
Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CA

233
C:\Windows\system32\drivers\usbhub.sys

234
C:\Windows\system32\drivers\usbport.sys

235
C:\Windows\system32\drivers\usbuhci.sys

236
Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27C8

237
C:\Windows\system32\drivers\usbhub.sys

238
C:\Windows\system32\drivers\usbport.sys

239
C:\Windows\system32\drivers\usbuhci.sys

240
Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CC

241
C:\Windows\system32\drivers\usbehci.sys

242
C:\Windows\system32\drivers\usbhub.sys

243
C:\Windows\system32\drivers\usbport.sys

244
USB-Massenspeichergeräte

245
C:\Windows\system32\drivers\USBSTOR.SYS

246
USB-Root-Hub

247
C:\Windows\system32\drivers\usbd.sys

248
C:\Windows\system32\drivers\usbhub.sys

249
USB-Root-Hub

250
C:\Windows\system32\drivers\usbd.sys

251
C:\Windows\system32\drivers\usbhub.sys

252
USB-Root-Hub

253
C:\Windows\system32\drivers\usbd.sys

254
C:\Windows\system32\drivers\usbhub.sys

255
USB-Root-Hub

256
C:\Windows\system32\drivers\usbd.sys

257
C:\Windows\system32\drivers\usbhub.sys

258
USB-Root-Hub

259
C:\Windows\system32\drivers\usbd.sys

260
C:\Windows\system32\drivers\usbhub.sys

261
USB-Verbundgeräte

262
C:\Windows\system32\drivers\usbccgp.sys

263

Worksheet: DeviceManagerProperties

03-20-2018, 04:09 PM
DocAElstein

slkhflskhfslkhf
03-20-2018, 04:09 PM
DocAElstein

Device Manager Property list against drivers and DriverStore
Device Manager Property list against DriverStore [ and drivers ]
Worksheets comparison
The summary listing for the matched files is given by the macro here: http://www.excelfox.com/forum/showth...ll=1#post12522
The output is arranged as follows
File types in Device Manager ( matched in DriverStore ) [ also in drivers ]
To avoid making any mistake in the logic, we need to carefully consider what text formatting conditions,
we can remain with
____If rngStr.Value = "" Then
followed by
______ If Left(rngStr.Value, 3) = "C:" And InStr(4, rngStr.Value, ".", vbBinaryCompare) > 1 Then
In order to have a cell with a path containing a file.

Colouring alone is no longer an indication of a matched cell, since this might be a non matched cell that was matched to drivers
It is the Italic text , alone which indicates a ( match to DriverStore ) : If also the text is underlined, then we have also had this file [ matched previously to drivers ]

If I am not mistaken, the code snippet below would be a typical appropriate logic code line to achieve filling the corresponding 3 variables, if appropriate, to indicate the presence of a file type in
__ Device Manager __ ( DriverStore ) __ [ drivers ]

Code:

Case "SYS" Let Sys = Sys + 1: If rngStr.Font.Italic = True Then Let Sys2 = Sys2 + 1: If rngStr.Font.Underline = xlUnderlineStyleSingle Then Let Sys3 = Sys3 + 1

An entry must be both in Device Manager and be italicised , before it is possible to be underlined. Hence the long line use is valid

For the above code snippet, the corresponding output code line is

Code:

Debug.Print "sys " & Sys & " (" & Sys2 & ") [" & Sys3 & "]"

The results from running the macro give us

Code:

sys 95 (68) [38] dll 13 (11) [1] bin 6 (2) [0] cpa 1 (1) [0] vp 5 (5) [0] els 0 (0) [0] Totals 120 (87) [39]

ExplorerBefore Device Manager Properties V DriverStore.xlsm : https://app.box.com/s/tgd6k3sgs1d0w09dhlizuq8a9asvmu2k
03-20-2018, 04:09 PM
DocAElstein

slkhflskhfslkhf
03-20-2018, 04:09 PM
DocAElstein

slkhflskhfslkhf
03-20-2018, 04:09 PM
DocAElstein

slkhflskhfslkhf

Show 40 post(s) from this thread on one page

_Row\^Col	C	E
212	UMBus-Stamm-Busenumerator
213		C:\Windows\system32\DRIVERS\umbus.sys
214

_Row\^Col	B	E
3791	G:\Win 10 Devices\Before\DriverStore\FileRepository\umbus.in f_amd64_30be546bea6ffa86	umbus.inf_amd64_30be546bea6ffa86
3792		umbus.inf
3793		umbus.PNF
3794		umbus.sys

_Row\^Col	B	E
1307	G:\Win 10 Devices\Before\DriverStore\FileRepository\keyboard .inf_amd64_e085085e52ff47cf	keyboard.inf_amd64_e085085e52ff47cf
1308		i8042prt.sys
1309		kbdclass.sys
1310		kbdhid.sys
1311		keyboard.inf
1312		keyboard.PNF
1313

_Row\^Col	C	E	F
219	USB_China2
220			C:\Windows\system32\DRIVERS\UMDF\WpdFs.dll
221		C:\Windows\system32\drivers\WpdUpFltr.sys
222		C:\Windows\system32\DRIVERS\WUDFRd.sys
223

_Row\^Col	B	E
4311	G:\Win 10 Devices\Before\DriverStore\FileRepository\wpdfs.in f_amd64_863b4f7bd336d637	wpdfs.inf_amd64_863b4f7bd336d637
4312		WpdFs.dll
4313		wpdfs.inf
4314		wpdfs.PNF

G:\Win 10 Devices\Before\DriverStore\FileRepository\tsusbhub .inf_amd64_553447f844bdec99			tsusbhub.inf_amd64_553447f844bdec99
			tsusbhub.inf
			tsusbhub.sys

G:\Win 10 Devices\Before\DriverStore\FileRepository\tsusbhub .inf_amd64_71bafe46689e1f9c			tsusbhub.inf_amd64_71bafe46689e1f9c
			tsusbhub.inf
			tsusbhub.sys

_Row\^Col	B	E
3849	G:\Win 10 Devices\Before\DriverStore\FileRepository\usbport. inf_amd64_6c8d049f5073a198	usbport.inf_amd64_6c8d049f5073a198
3850		usbd.sys
3851		usbehci.sys
3852		usbhub.sys
3853		usbohci.sys
3854		usbport.inf
3855		usbport.PNF
3856		usbport.sys
3857		usbuhci.sys
3858

_Row\^Col	B	E
3811	G:\Win 10 Devices\Before\DriverStore\FileRepository\usb.inf_ amd64_3b351e8afee70f3b	usb.inf_amd64_3b351e8afee70f3b
3812		usb.inf
3813		usb.PNF
3814		usbccgp.sys
3815