Windows 10 and Office Excel

**DocAElstein** · 02-07-2018, 03:49 PM

Trying to tie down / compare a bit more precisely the actual files

I will take each of the 20 things in the list from the Device Manager Properties and see if I can match the actual files at the end of a string with anything in the Double Driver List.

So for example for the first thing, Audio, Video und Gamecontroller , we are looking for the files here:
Comparing Device Drivers Selection.JPG : https://imgur.com/GSjjdod
Comparing Device Drivers Selection.JPG

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

Audio, Video und Gamecontroller
	High definition Audio-Gerät
			C:\Windows\system32\DRIVERS\dmk.sys
			C:\Windows\system32\DRIVERS\HdAudio.sys
			C:\Windows\system32\drivers\ksthunk.sys
			C:\Windows\system32\DRIVERS\portcls.sys
		C:\Windows\system32\SysFxUl.dll
		C:\Windows\system32\WMALFXGFXDSP.dll

Worksheet: DeviceManagerProperties

I will look for those in the entire files shown in the DDAllBefore worksheet.
_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

	netrasa.inf

Printer

	HP LaserJet Pro 200 color MFP M275 PCL6 Class Driver
	restore.ini
	prnhpcl3.inf
	prnhpcl3.cat

		amd64
		hpcP6wn8_CA.GPD

Worksheet: DDAllBefore

Code:


Local Print Queue	
restore.ini	
printqueue.inf	
	
	
	
Intel(R) 82801G (ICH7 Family) USB Universal Host Controller - 27C8	
restore.ini	
usbport.inf	
usbehci.sys	
usbport.sys	
usbohci.sys	
usbuhci.sys	
usbhub.sys	
usbd.sys	
	
Intel(R) 82801G (ICH7 Family) USB Universal Host Controller - 27C9	
restore.ini	
usbport.inf	
usbehci.sys	
usbport.sys	
usbohci.sys	
usbuhci.sys	
usbhub.sys	
usbd.sys	
	
Intel(R) 82801G (ICH7 Family) USB Universal Host Controller - 27CA	
restore.ini	
usbport.inf	
usbehci.sys	
usbport.sys	
usbohci.sys	
usbuhci.sys	
usbhub.sys	
usbd.sys	
	
Intel(R) 82801G (ICH7 Family) USB Universal Host Controller - 27CB	
restore.ini	
usbport.inf	
usbehci.sys	
usbport.sys	
usbohci.sys	
usbuhci.sys	
usbhub.sys	
usbd.sys	
	
Intel(R) 82801G (ICH7 Family) USB2 Enhanced Host Controller - 27CC	
restore.ini	
usbport.inf	
usbehci.sys	
usbport.sys	
usbohci.sys	
usbuhci.sys	
usbhub.sys	
usbd.sys	
	
USB Root Hub	
restore.ini	
usbport.inf	
usbehci.sys	
usbport.sys	
usbohci.sys	
usbuhci.sys	
usbhub.sys	
usbd.sys	
	
USB Mass Storage Device	
restore.ini	
usbstor.inf	
usbstor.sys	
	
USB Composite Device	
restore.ini	
usb.inf	
usbccgp.sys	
	
	
	
CD-ROM Drive	
restore.ini	
cdrom.inf	
cdrom.sys	
	
	
	
ACPI x64-based PC	
restore.ini	
hal.inf	
	
	
	
Disk drive	
restore.ini	
disk.inf	
disk.sys	
	
	
	
Intel(R) G41 Express Chipset (Microsoft Corporation - WDDM 1.1)	
restore.ini	
oem2.inf	
igdlh.cat	
igdkmd64.sys	
igdumd64.dll	
igdumd32.dll	
igkrng500.bin	
igcompkrng500.bin	
igfcg500m.bin	
iglhxs64.vp	
iglhxo64.vp	
iglhxc64.vp	
iglhxg64.vp	
iglhxa64.vp	
iglhxa64.cpa	
iglhcp64.dll	
iglhcp32.dll	
iglhsip64.dll	
iglhsip32.dll	
igd10umd32.dll	
igd10umd64.dll	
	
	
	
Intel(R) 82801GB-GR-GH (ICH7 Family) Serial ATA Storage Controller - 27C0	
restore.ini	
mshdc.inf	
storahci.sys	
intelide.sys	
storprop.dll	
atapi.sys	
ataport.sys	
pciidex.sys	
pciide.sys	
	
IDE Channel	
restore.ini	
mshdc.inf	
storahci.sys	
intelide.sys	
storprop.dll	
atapi.sys	
ataport.sys	
pciidex.sys	
pciide.sys	
	
	
	
HID Keyboard Device	
restore.ini	
keyboard.inf	
i8042prt.sys	
kbdclass.sys	
kbdhid.sys	
	
	
	
High Definition Audio-Gerät	
restore.ini	
hdaudio.inf	
hdaudio.sys	
	
Microsoft Streaming Clock Proxy	
restore.ini	
ksfilter.inf	
	
Microsoft Streaming Service Proxy	
restore.ini	
ksfilter.inf	
	
Microsoft Streaming Quality Manager Proxy	
restore.ini	
ksfilter.inf	
	
Microsoft Streaming Tee-Sink-to-Sink Converter	
restore.ini	
ksfilter.inf	
	
Microsoft Trusted Audio Drivers	
restore.ini	
wdmaudio.inf	
portcls.sys	
MsApoFxProxy.dll	
drmk.sys	
drmkaud.sys	
sysfxui.dll	
wmalfxgfxdsp.dll	
	
	
	
Generic PnP Monitor	
restore.ini	
monitor.inf	
monitor.sys	
	
Generic Non-PnP Monitor	
restore.ini	
monitor.inf	
monitor.sys	
	
	
	
HID-compliant mouse	
restore.ini	
msmouse.inf	
mouclass.sys	
sermouse.sys	
mouhid.sys	
	
	
	
Microsoft Kernel Debug Network Adapter	
restore.ini	
kdnic.inf	
kdnic.sys	
	
Realtek PCIe GBE Family Controller	
restore.ini	
rt640x64.inf	
rt640x64.sys	
	
WAN Miniport (SSTP)	
restore.ini	
netsstpa.inf	
	
WAN Miniport (IKEv2)	
restore.ini	
netavpna.inf	
	
WAN Miniport (L2TP)	
restore.ini	
netrasa.inf	
	
WAN Miniport (PPTP)	
restore.ini	
netrasa.inf	
	
WAN Miniport (PPPOE)	
restore.ini	
netrasa.inf	
	
WAN Miniport (IP)	
restore.ini	
netrasa.inf	
	
WAN Miniport (IPv6)	
restore.ini	
netrasa.inf	
	
WAN Miniport (Network Monitor)	
restore.ini	
netrasa.inf	
	
	
	
HP LaserJet Pro 200 color MFP M275 PCL6 Class Driver	
restore.ini	
prnhpcl3.inf	
prnhpcl3.cat	
	
	amd64
	hpcP6wn8_CA.GPD
	hppcl6_CA-manifest.ini
	hpcPCL6_PipelineConfig.xml
	hpcCFGP6.GDL
	hpcP6wn8_MA.GPD
	hppcl6_MA-manifest.ini
	hpcP6wn8_CB.GPD
	hppcl6_CB-manifest.ini
	hpcP6wn8_MB.GPD
	hppcl6_MB-manifest.ini
	hpcP6wn8_MA_HWCP.GPD
	hppcl6_MA_HWCP-manifest.ini
	hpcP6wn8_CA_OJEF.GPD
	hppcl6_CA_OJEF-manifest.ini
	hpcP6wn8_CB_HWCP.GPD
	hppcl6_CB_HWCP-manifest.ini
	hpcP6wn8_CA_HWCP.GPD
	hppcl6_CA_HWCP-manifest.ini
	hpc6mw81.gpd
	hpcstw81.dll
	hpcfltw8.dll
	hpcfltwb.dll
	hppcl6usbext.js
	hppcl6usbext.xml
	hppcl6wsdext.xml
	
Brother Laser Type1 Class Driver	
restore.ini	
prnbrcl1.inf	
PRNBRCL1.CAT	
BRIBMF01.GPD	
BRIBMF01-PIPELINECONFIG.XML	
BRIBMF01-MANIFEST.INI	
BRIBMF02.GPD	
BRIBMF02-PIPELINECONFIG.XML	
BRIBMF02-MANIFEST.INI	
BRIBMF03.GPD	
BRIBMF03-PIPELINECONFIG.XML	
BRIBMF03-MANIFEST.INI	
BRIBMF04.GPD	
BRIBMF04-PIPELINECONFIG.XML	
BRIBMF04-MANIFEST.INI	
BRIBMF05.GPD	
BRIBMF05-PIPELINECONFIG.XML	
BRIBMF05-MANIFEST.INI	
BRIBMF05.dpb	
BRIBMF06.GPD	
BRIBMF06-PIPELINECONFIG.XML	
BRIBMF06-MANIFEST.INI	
BRIBMF06.dpb	
BRIBMF07.GPD	
BRIBMF07-PIPELINECONFIG.XML	
BRIBMF07-MANIFEST.INI	
BRIBMF07.dpb	
BRIBMF08.GPD	
BRIBMF08-PIPELINECONFIG.XML	
BRIBMF08-MANIFEST.INI	
BRIBMF08.dpb	
BRIBMF0C.GPD	
BRIBMF0C-PIPELINECONFIG.XML	
BRIBMF0C-MANIFEST.INI	
BRIBMF0D.GPD	
BRIBMF0D-PIPELINECONFIG.XML	
BRIBMF0D-MANIFEST.INI	
BRIBMF0E.PPD	
BRIBMF0E-PIPELINECONFIG.XML	
BRIBMF0E-MANIFEST.INI	
BRIBREM00.GPD	
BRIBMM0A.GPD	
BRIBMM0A-PIPELINECONFIG.XML	
BRIBMM0A-MANIFEST.INI	
BRIBMM0B.GPD	
BRIBMM0B-PIPELINECONFIG.XML	
BRIBMM0B-MANIFEST.INI	
BRIBMM0C.GPD	
BRIBMM0C-PIPELINECONFIG.XML	
BRIBMM0C-MANIFEST.INI	
BRIBMM0D.GPD	
BRIBMM0D-PIPELINECONFIG.XML	
BRIBMM0D-MANIFEST.INI	
BRIBME0A_200.gpd	
BRIBME0A_200-MANIFEST.INI	
BRIBME0A_200-PipelineConfig.xml	
BRIBME0A_300.gpd	
BRIBME0A_300-MANIFEST.INI	
BRIBME0A_300-PipelineConfig.xml	
BRIBRE01.gpd	
	
	amd64
	BRIBEN01.DLL
	BRIBEN02.DLL
	BRIBEN03.DLL
	BRIBEN04.DLL
	BRIBEN05.DLL
	BRIBEN06.DLL
	BRIBEN07.DLL
	BRIBEN08.DLL
	BRIBEN0C.DLL
	BRIBFRM00.DLL
	BRIBFFM00.DLL
	BRIBFPM00.DLL
	BRIBFLM00.DLL
	BRIBFTM00.DLL
	BRIBFCM00.DLL
	BRIBREM00.DLL
	BRIBMM0A.DLL
	BRIBMM0B.DLL
	BRIBMM0C.DLL
	BRIBFFI01.DLL
	BRIBFRA01.DLL
	BRIBFPR01.DLL
	BRIBFPJ01.DLL
	BRIBRE01.dll
	BRIBME0A.dll
	
HP OfficeJet Pro 8720 PCL-3	
restore.ini	
oem3.inf	
hpygid20_v4.cat	
hpgid20v4-PipelineConfig.xml	
hpgid20v4cfg.gdl	
hpgid20v4map.xml	
hpgid20v4que.xml	
hpgid20v4-constraints.js	
hpgid20v4-bidiEvent.xml	
hpgid20v4-bidiSPM.xml	
hpgid20v4-bidiWSD.xml	
hpgid20v4-bidiUSB.js	
hpgid20v4help.cab	
hp8720.bag	
hpygid20_8720-manifest.ini	
hpgid20v4-bidiUSB-OPA.xml	
	
	amd64
	hpbxpsv420.dll
	hpygiddrv20.dll
	hpUIMDDialog20.dll
	hpgid20v4PE.exe
	hpygidres20.dll
	hpgid20v4_symbols.gpd
	userfors.dll
	hpgid20v4PELib.dll
	hpoj_8720_v4.gpd
	
	
	
Microsoft Storage Spaces Controller	
restore.ini	
spaceport.inf	
spaceport.sys	
spacedump.sys	
	
	
	
Composite Bus Enumerator	
restore.ini	
compositebus.inf	
CompositeBus.sys	
	
UMBus Root Bus Enumerator	
restore.ini	
umbus.inf	
umbus.sys	
	
NDIS Virtual Network Adapter Enumerator	
restore.ini	
ndisvirtualbus.inf	
	
Plug and Play Software Device Enumerator	
restore.ini	
swenum.inf	
swenum.sys	
	
Remote Desktop Device Redirector Bus	
restore.ini	
rdpbus.inf	
rdpbus.sys	
	
Microsoft ACPI-Compliant System	
restore.ini	
acpi.inf	
acpi.sys	
	
ACPI Power Button	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
PCI Bus	
restore.ini	
pci.inf	
pci.sys	
	
System board	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
Legacy device	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
ACPI Fixed Feature Button	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
CPU to IO Controller	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
High Definition Audio Controller	
restore.ini	
hdaudbus.inf	
hdaudbus.sys	
	
PCI-to-PCI Bridge	
restore.ini	
pci.inf	
pci.sys	
	
LPC Controller	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
SM Bus Controller	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
Motherboard resources	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
Programmable interrupt controller	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
Direct memory access controller	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
System timer	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
High precision event timer	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
System CMOS-real time clock	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
System speaker	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
Numeric data processor	
restore.ini	
machine.inf	
msisadrv.sys	
isapnp.sys	
	
Microsoft Virtual Drive Enumerator	
restore.ini	
vdrvroot.inf	
vdrvroot.sys	
	
Volume Manager	
restore.ini	
volmgr.inf	
volmgr.sys	
	
Microsoft Basic Display Driver	
restore.ini	
basicdisplay.inf	
BasicDisplay.sys	
	
Microsoft Basic Render Driver	
restore.ini	
basicrender.inf	
BasicRender.sys	
	
Microsoft System Management BIOS Driver	
restore.ini	
mssmbios.inf	
mssmbios.sys	
	
	
	
Intel Processor	
restore.ini	
cpu.inf	
processr.sys	
intelppm.sys	
amdk8.sys	
amdppm.sys	
	
	
	
Generic volume shadow copy	
restore.ini	
volsnap.inf	
	
	
	
Generic software device	
restore.ini	
c_swdevice.inf	
	
	
	
Texas Instruments 1394 OHCI Compliant Host Controller	
restore.ini	
1394.inf	
1394ohci.sys	
	
	
	
WSD-Scandienst	
restore.ini	
wsdscdrv.inf	
WSDScDrv.dll	
	
	
	
Volume	
restore.ini	
volume.inf	
volume.sys	
	
	
	
USB Input Device	
restore.ini	
input.inf	
hidusb.sys	
hidclass.sys	
hidparse.sys	
	
HID-compliant consumer control device	
restore.ini	
hidserv.inf	
	
HID-compliant system controller	
restore.ini	
input.inf	
hidusb.sys	
hidclass.sys	
hidparse.sys	
	
HID-compliant vendor-defined device	
restore.ini	
input.inf	
hidusb.sys	
hidclass.sys	
hidparse.sys	
	
	
	
Audio Endpoint	
restore.ini	
audioendpoint.inf	
	
	
	
WSD Print Device	
restore.ini	
wsdprint.inf	
wsdprint.sys	
	
	
	
WPD-Dateisystem-Volumetreiber	
restore.ini	
wpdfs.inf	
wpdfs.dll

**DocAElstein** · 02-08-2018, 12:53 AM

Coding idea to tie down / compare a bit more precisely the actual files

A basic code idea.
I am comparing the files found from Device Manager Driver details properties to those in the full list obtained from the Double Driver software.
I will try to find the each of the files in the files found from Device Manager Driver details properties in the full list obtained from the Double Driver software

I will make a selection in the worksheet , DeviceManagerProperties , to include all the files of interest, so this would typically be a selection to include all the files listed
Comparing Device Drivers Selection.JPG : https://imgur.com/GSjjdod
Comparing Device Drivers Selection.JPG

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

Audio, Video und Gamecontroller
	High definition Audio-Gerät
			C:\Windows\system32\DRIVERS\dmk.sys
			C:\Windows\system32\DRIVERS\HdAudio.sys
			C:\Windows\system32\drivers\ksthunk.sys
			C:\Windows\system32\DRIVERS\portcls.sys
		C:\Windows\system32\SysFxUl.dll
		C:\Windows\system32\WMALFXGFXDSP.dll

Worksheet: DeviceManagerProperties

The macro should then take each cell in the selection, check for a file in the cell, then if found it will look for that file in all the columns containing files in the Double Driver All Devices worksheet, DDAllBefore

I have the coding for convenience in the Worksheets code module of worksheet DeviceManagerProperties
So any undefined Range references will refer to that worksheet. But I will try to avoid relying on that in case I copy the code , or parts thereof, elsewhere later
I will not make any attempt to do an efficient macro: I will select and color matching pairs in the two worksheets as I go along. If it goes a bit slow that can be helpful for seeing where things are
Here is a coding example:

Code:

Sub CompareDriverFilesDeviceManagerInDoubleDriverAllList()
Rem 0
    If ActiveSheet.Name <> "DeviceManagerProperties" Then
     MsgBox prompt:="Oops": Exit Sub
    Else
    End If
Rem 1 Worksheets info
Dim WsDMP As Worksheet, WsDDA As Worksheet
 Set WsDMP = Worksheets("DeviceManagerProperties"): Set WsDDA = Worksheets("DDAllBefore")

Rem 2 Looking at each cell in the selection
' Random number between 3 and 56 to get color index for any matching file names (1 is black, 2 is white , up to 56 is other colors:  3 to 56   is like  (0 to 53)+3  Rnd gives like  0-.99999  so (Int(Rnd*54))+3  is what we want
Dim ClrIdx As Long
 Randomize: Let ClrIdx = (Int(Rnd * 54)) + 3

Dim SrchForCel As Range
    For Each SrchForCel In Selection ' Take each cell in selected range
    Dim CelVl As String: Let CelVl = SrchForCel.Value
        If CelVl <> "" And Left(CelVl, 3) = "C:\" And InStr(4, CelVl, ".", vbBinaryCompare) > 1 Then ' use some criteria to check we have a file path
        Dim FileNmeSrchFor As String
         Let FileNmeSrchFor = Right(CelVl, (Len(CelVl)) - (InStrRev(CelVl, "\", -1, vbBinaryCompare))) ' Determine the file name as that looking from the right as many characters as (the total character number) - (the position looking from the right of a "\")
        Rem 3 We now should have a file name, so we look for it in worksheet  DDAllBefore
        Dim SrchRng As Range: Set SrchRng = Application.Range("=DDAllBefore!F5:DDAllBefore!G670")    ' WsDDA.Range("=F5:G670")
        Dim FndCel As Range
         Set FndCel = SrchRng.Find(what:=FileNmeSrchFor, After:=Application.Range("=DDAllBefore!F5"), LookAt:=xlPart, searchorder:=xlNext, MatchCase:=False) '
            If Not FndCel Is Nothing Then ' the range is set, so the file string has been found in a cell in  DDAllBefore
            Rem 4 we have two matching cells
             'Debug.Print FndCel.Value
            '4b) color matching file names in each worksheet, we do the unecerssary activating and selecting so we can see what is going in
             WsDMP.Activate: SrchForCel.Select
             Let SrchForCel.Characters(((InStrRev(CelVl, "\", -1, vbBinaryCompare)) + 1), (Len(CelVl)) - (InStrRev(CelVl, "\", -1, vbBinaryCompare))).Font.ColorIndex = ClrIdx
             WsDDA.Activate: FndCel.Select
             Let FndCel.Font.ColorIndex = ClrIdx
            Else ' No match was found - the thing in the cell in
            End If
        Else ' case no file path string in cell
        End If
    Next SrchForCel
End Sub

In the next posts are the screenshots for running the code on the selection
Comparing Device Drivers Selection.JPG : https://imgur.com/GSjjdod
Comparing Device Drivers Selection.JPG

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

Audio, Video und Gamecontroller
	High definition Audio-Gerät
			C:\Windows\system32\DRIVERS\dmk.sys
			C:\Windows\system32\DRIVERS\HdAudio.sys
			C:\Windows\system32\drivers\ksthunk.sys
			C:\Windows\system32\DRIVERS\portcls.sys
		C:\Windows\system32\SysFxUl.dll
		C:\Windows\system32\WMALFXGFXDSP.dll

Worksheet: DeviceManagerProperties

**DocAElstein** · 02-12-2018, 08:38 PM

Continued from last post….

Here is the selected range before the macro is run
Comparing Device Drivers Selection.JPG : https://imgur.com/GSjjdod
Comparing Device Drivers Selection.JPG

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col	B	C	D	E
2	Audio, Video und Gamecontroller
3		High definition Audio-Gerät
4				C:\Windows\system32\DRIVERS\dmk.sys
5				C:\Windows\system32\DRIVERS\HdAudio.sys
6				C:\Windows\system32\drivers\ksthunk.sys
7				C:\Windows\system32\DRIVERS\portcls.sys
8			C:\Windows\system32\SysFxUl.dll
9			C:\Windows\system32\WMALFXGFXDSP.dll

Worksheet: DeviceManagerProperties

_.______________________________

After running , Sub CompareDriverFilesDeviceManagerInDoubleDriverAllLi st() , we see the matched files highlighted:

Worksheet for Files obtained from Device Manager Properties:

Audio, Video und Gamecontroller
	High definition Audio-Gerät
			C:\Windows\system32\DRIVERS\dmk.sys
			C:\Windows\system32\DRIVERS\HdAudio.sys
			C:\Windows\system32\drivers\ksthunk.sys
			C:\Windows\system32\DRIVERS\portcls.sys
		C:\Windows\system32\SysFxUl.dll
		C:\Windows\system32\WMALFXGFXDSP.dll

Worksheet: DeviceManagerProperties

Worksheet for Double Driver full list:

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA	MEDIA

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\High Definition Audio-Gerät		High Definition Audio-Gerät
		restore.ini
		hdaudio.inf
		hdaudio.sys

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Streaming Clock Proxy		Microsoft Streaming Clock Proxy
		restore.ini
		ksfilter.inf

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Streaming Service Proxy		Microsoft Streaming Service Proxy
		restore.ini
		ksfilter.inf

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Streaming Quality Manager Proxy		Microsoft Streaming Quality Manager Proxy
		restore.ini
		ksfilter.inf

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Streaming Tee-Sink-to-Sink Converter		Microsoft Streaming Tee-Sink-to-Sink Converter
		restore.ini
		ksfilter.inf

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Trusted Audio Drivers		Microsoft Trusted Audio Drivers
		restore.ini
		wdmaudio.inf
		portcls.sys
		MsApoFxProxy.dll
		drmk.sys
		drmkaud.sys
		sysfxui.dll
		wmalfxgfxdsp.dll

Worksheet: DDAllBefore

In the following posts are the results for other selections. ( I have modified the coding slightly as the current excel fox BB Code generator makes it difficult to catch partial cell character colouring. So I replace the code line which colours just the file characters, with a code line to color the entire string (which includes the file path for my hand made from Device Manager Properties). This is the replacement code line
Let SrchForCel.Font.ColorIndex = ClrIdx
It replaces this:
Let SrchForCel.Characters(((InStrRev(CelVl, "", -1, vbBinaryCompare)) + 1), (Len(CelVl)) - (InStrRev(CelVl, "", -1, vbBinaryCompare))).Font.ColorIndex = ClrIdx

Code:

            '4b) color matching file names in each worksheet, we do the unecerssary activating and selecting so we can see what is going in
             WsDMP.Activate: SrchForCel.Select
             'Let SrchForCel.Characters(((InStrRev(CelVl, "\", -1, vbBinaryCompare)) + 1), (Len(CelVl)) - (InStrRev(CelVl, "\", -1, vbBinaryCompare))).Font.ColorIndex = ClrIdx
             Let SrchForCel.Font.ColorIndex = ClrIdx
             Let SrchForCel.Font.Color = ClrIdx
             WsDDA.Activate: FndCel.Select
             Let FndCel.Font.ColorIndex = ClrIdx
            Else ' No match was found - the thing in the cell in

**DocAElstein** · 02-17-2018, 05:06 PM

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

Audio, Video und Gamecontroller
	High definition Audio-Gerät
			C:\Windows\system32\DRIVERS\dmk.sys
			C:\Windows\system32\DRIVERS\HdAudio.sys
			C:\Windows\system32\drivers\ksthunk.sys
			C:\Windows\system32\DRIVERS\portcls.sys
		C:\Windows\system32\SysFxUl.dll
		C:\Windows\system32\WMALFXGFXDSP.dll
	High definition Audio-Gerät
			C:\Windows\system32\DRIVERS\dmk.sys
			C:\Windows\system32\DRIVERS\HdAudio.sys
			C:\Windows\system32\drivers\ksthunk.sys
			C:\Windows\system32\DRIVERS\portcls.sys
		C:\Windows\system32\SysFxUl.dll
		C:\Windows\system32\WMALFXGFXDSP.dll

Worksheet: DeviceManagerProperties

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA	MEDIA

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\High Definition Audio-Gerät		High Definition Audio-Gerät
		restore.ini
		hdaudio.inf
		hdaudio.sys

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Streaming Clock Proxy		Microsoft Streaming Clock Proxy
		restore.ini
		ksfilter.inf

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Streaming Service Proxy		Microsoft Streaming Service Proxy
		restore.ini
		ksfilter.inf

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Streaming Quality Manager Proxy		Microsoft Streaming Quality Manager Proxy
		restore.ini
		ksfilter.inf

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Streaming Tee-Sink-to-Sink Converter		Microsoft Streaming Tee-Sink-to-Sink Converter
		restore.ini
		ksfilter.inf

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\MEDIA\Microsoft Trusted Audio Drivers		Microsoft Trusted Audio Drivers
		restore.ini
		wdmaudio.inf
		portcls.sys
		MsApoFxProxy.dll
		drmk.sys
		drmkaud.sys
		sysfxui.dll
		wmalfxgfxdsp.dll

Worksheet: DDAllBefore
Note : The same files are matched in this last example in the Double Driver list as in the previous case

**DocAElstein** · 02-17-2018, 05:06 PM

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col	B	C
17	Audioeingänge und - ausgänge
18		47PL3605h(High definition Audio-Gerät
19
20		Digitalaudio (S/PDIF) (2 - High Definition Audio.Gerät)
21
22		Digitalaudio (S/PDIF) (2 - High Definition Audio.Gerät)
23
24	Computer
25		ACIPx64-basierter PC
26
27	Druckwarteshlangen
28		Fax
29
30		Micrtosoft print to PDF
31
32		Microsoft XPS Document Writer
33
34		OneNote
35
36		Stammdruckwarteshlange
37

Worksheet: DeviceManagerProperties

No device properties were given for the above

**DocAElstein** · 02-23-2018, 03:16 PM

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

DVD/CD-ROM-Laufwerke
	TSSTcorpDVD-ROM SH-D163C ATA Device
		C:\Windows\system32\DRIVERS\cdrom.sys

Worksheet: DeviceManagerProperties

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\CDROM\CD-ROM Drive				CD-ROM Drive
				restore.ini
				cdrom.inf
				cdrom.sys

Worksheet: DDAllBefore

**DocAElstein** · 02-28-2018, 12:22 AM

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

_Row\^Col	B	C	E
41	Eingabegeräte (Human Interface Device)
42		HID-Konformer Sysgtemcontroller
43
44		HID-Konformer Benutzersteuergeräte
45
46		HID-Konformer vom Hersteller definiertes Gerät
47
48		HID-Konformer vom Hersteller definiertes Gerät
49
50		USB-Eingabegerät
51			C:\Windows\system32\DRIVERS\hidclass.sys
52			C:\Windows\system32\DRIVERS\hidparse.sys
53			C:\Windows\system32\DRIVERS\hidusb.sys
54		USB-Eingabegerät
55			C:\Windows\system32\DRIVERS\hidclass.sys
56			C:\Windows\system32\DRIVERS\hidparse.sys
57			C:\Windows\system32\DRIVERS\hidusb.sys

Worksheet: DeviceManagerProperties

Not all Human Interface devices had Properties listed

**DocAElstein** · 02-28-2018, 12:22 AM

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

Eingabegeräte (Human Interface Device)
	HID-Konformer Sysgtemcontroller

	HID-Konformer Benutzersteuergeräte

	HID-Konformer vom Hersteller definiertes Gerät

	HID-Konformer vom Hersteller definiertes Gerät

	USB-Eingabegerät
		C:\Windows\system32\DRIVERS\hidclass.sys
		C:\Windows\system32\DRIVERS\hidparse.sys
		C:\Windows\system32\DRIVERS\hidusb.sys

Worksheet: DeviceManagerProperties

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\HIDClass\USB Input Device				USB Input Device
				restore.ini
				input.inf
				hidusb.sys
				hidclass.sys
				hidparse.sys

Worksheet: DDAllBefore

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

Eingabegeräte (Human Interface Device)
	HID-Konformer Sysgtemcontroller

	HID-Konformer Benutzersteuergeräte

	HID-Konformer vom Hersteller definiertes Gerät

	HID-Konformer vom Hersteller definiertes Gerät

	USB-Eingabegerät
		C:\Windows\system32\DRIVERS\hidclass.sys
		C:\Windows\system32\DRIVERS\hidparse.sys
		C:\Windows\system32\DRIVERS\hidusb.sys
	USB-Eingabegerät
		C:\Windows\system32\DRIVERS\hidclass.sys
		C:\Windows\system32\DRIVERS\hidparse.sys
		C:\Windows\system32\DRIVERS\hidusb.sys

Worksheet: DeviceManagerProperties

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\HIDClass\USB Input Device				USB Input Device
				restore.ini
				input.inf
				hidusb.sys
				hidclass.sys
				hidparse.sys

Worksheet: DDAllBefore
Note : The same files are matched in this last example in the Double Driver list as in the previous case

**DocAElstein** · 02-28-2018, 12:37 AM

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

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.dl
		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

Worksheet: DeviceManagerProperties
Note 1 file appears twice in the manually made Device Manager Properties List, but only once in the Double Driver Full list.
_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

igfcg500m.bin

Worksheet: DDAllBefore

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

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.dl

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

Worksheet: DeviceManagerProperties

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\Display\Intel(R) G41 Express Chipset (Microsoft Corporation - WDDM 1.1)				Intel(R) G41 Express Chipset (Microsoft Corporation - WDDM 1.1)
				restore.ini
				oem2.inf
				igdlh.cat
				igdkmd64.sys
				igdumd64.dll
				igdumd32.dll
				igkrng500.bin
				igcompkrng500.bin
				igfcg500m.bin
				iglhxs64.vp
				iglhxo64.vp
				iglhxc64.vp
				iglhxg64.vp
				iglhxa64.vp
				iglhxa64.cpa
				iglhcp64.dll
				iglhcp32.dll
				iglhsip64.dll
				iglhsip32.dll
				igd10umd32.dll
				igd10umd64.dll

Worksheet: DDAllBefore

**DocAElstein** · 03-01-2018, 06:02 PM

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

IDE ATA/ATAPI-Controller
	ATA Channel 0
		C:\Windows\system32\DRIVERS\atapi.sys
		C:\Windows\system32\DRIVERS\ataport.sys

	ATA Chanel 1
		C:\Windows\system32\DRIVERS\atapi.sys
		C:\Windows\system32\DRIVERS\ataport.sys

	Intel(R) 82801GB/GR/GH(ICH7 Familie) Serieller ATA-Speichercomtroller - 27C0
		C:\Windows\system32\DRIVERS\atapi.sys
		C:\Windows\system32\DRIVERS\ataport.sys
		C:\Windows\system32\DRIVERS\intelide.sys
		C:\Windows\system32\DRIVERS\pciidx.sys

Worksheet: DeviceManagerProperties
Note: we have 3 x 2 the same above

_____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )

G:\Win 10 Devices\Before\Double Driver Backup All\EG41MFT-US2H 09.02.2020 17-50-05\HDC\Intel(R) 82801GB-GR-GH (ICH7 Family) Serial ATA Storage Controller - 27C0				Intel(R) 82801GB-GR-GH (ICH7 Family) Serial ATA Storage Controller - 27C0
				restore.ini
				mshdc.inf
				storahci.sys
				intelide.sys
				storprop.dll
				atapi.sys
				ataport.sys
				pciidex.sys
				pciide.sys