Page 5 of 94 FirstFirst ... 345671555 ... LastLast
Results 41 to 50 of 935

Thread: Windows 10 and Office Excel

  1. 02-07-2018, 03:49 PM #41
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10

    Coding to help compare Bachup lists


    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



    Last edited by DocAElstein; 02-15-2020 at 01:25 PM.
    Reply With Quote Reply With Quote
  2. 02-08-2018, 12:53 AM #42
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10
    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
    Last edited by DocAElstein; 02-15-2020 at 01:29 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!
    Reply With Quote Reply With Quote
  3. 02-12-2018, 08:38 PM #43
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10
    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
    Last edited by DocAElstein; 02-15-2020 at 06:41 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!
    Reply With Quote Reply With Quote
  4. 02-17-2018, 05:06 PM #44
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10
    _____ 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
    Last edited by DocAElstein; 02-15-2020 at 07:37 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!
    Reply With Quote Reply With Quote
  5. 02-17-2018, 05:06 PM #45
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10
    _____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    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
    Last edited by DocAElstein; 02-15-2020 at 09:24 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!
    Reply With Quote Reply With Quote
  6. 02-23-2018, 03:16 PM #46
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10
    _____ 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
    Last edited by DocAElstein; 02-15-2020 at 07:37 PM.
    Reply With Quote Reply With Quote
  7. 02-28-2018, 12:22 AM #47
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10
    _____ Workbook: ExplorerViewDriversBefore.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    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
    Last edited by DocAElstein; 02-15-2020 at 09:28 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!
    Reply With Quote Reply With Quote
  8. 02-28-2018, 12:22 AM #48
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10
    _____ 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
    Last edited by DocAElstein; 02-15-2020 at 07:39 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!
    Reply With Quote Reply With Quote
  9. 02-28-2018, 12:37 AM #49
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10
    _____ 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
    Last edited by DocAElstein; 02-15-2020 at 07:39 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!
    Reply With Quote Reply With Quote
  10. 03-01-2018, 06:02 PM #50
    DocAElstein
    DocAElstein is offline
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,385
    Rep Power
    10
    _____ 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
    Worksheet: DDAllBefore
    Last edited by DocAElstein; 02-15-2020 at 07:40 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
     Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Tests and Notes on Range Referrencing
    By DocAElstein in forum Test Area
    Replies: 70
    Last Post: 02-20-2024, 01:54 AM
  2. Tests and Notes for EMail Threads
    By DocAElstein in forum Test Area
    Replies: 29
    Last Post: 11-15-2022, 04:39 PM
  3. Notes tests. Application.Run.OnTime Multiple Variable Arguments ByRef ByVal
    By DocAElstein in forum Test Area
    Replies: 39
    Last Post: 03-20-2018, 04:09 PM
  4. Notes tests. Excel VBA Folder File Search
    By DocAElstein in forum Test Area
    Replies: 39
    Last Post: 03-20-2018, 04:09 PM
  5. Excel Workbook ReOpening After Closing With Application.OnTime
    By leopaulc in forum Excel Help
    Replies: 2
    Last Post: 12-04-2012, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules