Appendix Thread. App Index Rws() Clms() Majic code line Codings for other Threads, Tables etc.)

**DocAElstein** · 02-05-2020, 10:50 PM

In support of this thread
http://www.excelfox.com/forum/showth...ll=1#post12138

Code:

dism.exe /Online /Get-Drivers  > "C:\Users\Elston\Desktop\3rdparty driverlist.txt"

Code:

Tool zur Imageverwaltung fr die Bereitstellung
Version: 10.0.17134.1

Abbildversion: 10.0.17134.1246

Liste der Treiber von Drittanbietern wird aus dem Treiberspeicher abgerufen...

Treiberpaketauflistung:

Ver"ffentlichter Name : oem0.inf
Originaldateiname : prnms009.inf
Windows-intern : Nein
Klassenname : Printer
Anbietername : Microsoft
Datum : 21.06.2006
Version : 10.0.17134.1

Ver"ffentlichter Name : oem1.inf
Originaldateiname : prnms001.inf
Windows-intern : Nein
Klassenname : Printer
Anbietername : Microsoft
Datum : 21.06.2006
Version : 10.0.17134.1

Ver"ffentlichter Name : oem2.inf
Originaldateiname : igdlh.inf
Windows-intern : Nein
Klassenname : Display
Anbietername : Intel Corporation
Datum : 11.03.2013
Version : 8.15.10.2702

Ver"ffentlichter Name : oem3.inf
Originaldateiname : hpygid20_v4.inf
Windows-intern : Nein
Klassenname : Printer
Anbietername : HP
Datum : 29.05.2017
Version : 20.79.1.6692

Der Vorgang wurde erfolgreich beendet.

Code:

 dism /online /export-driver /destination: "C:\Users\Elston\Desktop\driverbackupBefore" 
 Export-WindowsDriver -Online -Destination "C:\Users\MeinPC\Desktop\PowerShell driverbackup"

_____ Workbook: wbCodesBeforeFrom cmd prompt.xlsm ( Using Excel 2007 32 bit )

F:\Windows\Windows 10\Win 10 Devices\driverbackup	driverbackup

F:\Windows\Windows 10\Win 10 Devices\driverbackup\hpygid20_v4.inf_amd64_01bab60 e80914ef1		hpygid20_v4.inf_amd64_01bab60e80914ef1
		hp8720.bag
		hpgid20v4-bidiEvent.xml
		hpgid20v4-bidiSPM.xml
		hpgid20v4-bidiUSB-OPA.xml
		hpgid20v4-bidiUSB.js
		hpgid20v4-bidiWSD.xml
		hpgid20v4-constraints.js
		hpgid20v4-PipelineConfig.xml
		hpgid20v4cfg.gdl
		hpgid20v4help.cab
		hpgid20v4map.xml
		hpgid20v4que.xml
		hpygid20_8720-manifest.ini
		hpygid20_v4.cat
		hpygid20_v4.inf
		hpygid20_v4.PNF

F:\Windows\Windows 10\Win 10 Devices\driverbackup\hpygid20_v4.inf_amd64_01bab60 e80914ef1\amd64			amd64
			hpbxpsv420.dll
			hpgid20v4PE.exe
			hpgid20v4PELib.dll
			hpgid20v4_symbols.gpd
			hpoj_8720_v4.gpd
			hpUIMDDialog20.dll
			hpygiddrv20.dll
			hpygidres20.dll
			userfors.dll

F:\Windows\Windows 10\Win 10 Devices\driverbackup\igdlh.inf_amd64_c9077a4bbb395 caa		igdlh.inf_amd64_c9077a4bbb395caa
		igcompkrng500.bin
		igd10umd32.dll
		igd10umd64.dll
		igdkmd64.sys
		igdlh.cat
		igdlh.inf
		igdlh.PNF
		igdumd32.dll
		igdumd64.dll
		igfcg500m.bin
		igkrng500.bin
		iglhcp32.dll
		iglhcp64.dll
		iglhsip32.dll
		iglhsip64.dll
		iglhxa64.cpa
		iglhxa64.vp
		iglhxc64.vp
		iglhxg64.vp
		iglhxo64.vp
		iglhxs64.vp

F:\Windows\Windows 10\Win 10 Devices\driverbackup\prnms001.inf_amd64_cb0feabdd7 1f0e97		prnms001.inf_amd64_cb0feabdd71f0e97
		MXDW-manifest.ini
		MXDW-pipelineconfig.xml
		MXDW.gpd
		mxdwdui.dll
		prnms001.cat
		prnms001.Inf
		prnms001.PNF

F:\Windows\Windows 10\Win 10 Devices\driverbackup\prnms009.inf_amd64_5887f9f923 285dd6		prnms009.inf_amd64_5887f9f923285dd6
		MPDW-constraints.js
		MPDW-manifest.ini
		MPDW-PDC.xml
		MPDW-pipelineconfig.xml
		MPDW_devmode_map.xml
		prnms009.cat
		prnms009.Inf
		prnms009.PNF

Worksheet: cmd

**DocAElstein** · 02-08-2020, 07:32 PM

In support of this Post:
http://www.excelfox.com/forum/showth...ll=1#post12124

_____ Workbook: wbCodesBeforeFrom cmd prompt.xlsm ( Using Excel 2007 32 bit )


Audio, Video und Gamecontroller
	High definition Audio-Gerät






	High definition Audio-Gerät






Audioeingänge und - ausgänge
	47PL3605h(High definition Audio-Gerät

	Digitalaudio (S/PDIF) (2 - High Definition Audio.Gerät)

	Digitalaudio (S/PDIF) (2 - High Definition Audio.Gerät)

Computer
	ACIPx64-basierter PC

Druckwarteshlangen
	Fax

	Micrtosoft print to PDF

	Microsoft XPS Document Writer

	OneNote

	Stammdruckwarteshlange

DVD/CD-ROM-Laufwerke
	TSSTcorpDVD-ROM SH-D163C ATA Device

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



	USB-Eingabegerät



Grafikkarten
	Intel(R) G41 Express Chipset (Microsoft Corporation - WDDM 1.1)





















IDE ATA/ATAPI-Controller
	ATA Channel 0



	ATA Chanel 1



	Intel(R) 82801GB/GR/GH(ICH7 Familie) Serieller ATA-Speichercomtroller - 27C0




IEEE 1394-Hostcontroller
	OHCI-konformer texas Instruments1394-Hostcontroller

Laufwerk
	General UDisk USB Device



	SAMSUNG HD253GJ ATA Device



Mäuse und andere Zeigegeräte
	HID-konforme Mause


Monitore
	PnP-Monitore (Standard)

Netzwerkadaptor
	Realitek PCIe GBE Family Controller

	WAN Miniport (IKEv2)

	WAN Miniport (IP)


	WAN Miniport (IPv6)


	WAN Miniport (L2DP)

	WAN Miniport (Network Monitor)


	WAN Miniport (PPPOE)

	WAN Miniport (PPTP)

	WAN Miniport (SSTP)

Prozessoren
	Intel(R) Core(TM)2 Duo CPU E750 @ 2.93GHz

	Intel(R) Core(TM)2 Duo CPU E750 @ 2.93GHz

Softwaregeräte
	Brother DCP-1610W series [e89eb44818d]

	ELSTON-PC: elston:

	HPB6102A (HP Officejet Pro 8720)

	Microsoft Device Asssociation Root Enumerator

	Microsoft GS Wavetable Synthesis

	Microsoft RRAS Root Enumerator

	NPIA27BB4 (HP Laserjet 200 colorMFP M275nw)

Speichercontroller
	Microsoft-Controller für Speicherplätze


Systemgeräte
1	ACIP-Schalter

2	Busenumerator für Verbundgeräte
	compositebus.inf_amd64_bcb89b3386563bd7\CompositeB us.sys
3	CPU-zu-EA-Controller

4	DMA-Controller

5	Enumerator für virtuelle NDIS-Nertzwerkadaptor

6	High Definition Audio Controller




7	Hochpräzisionsereigniszeitgeber

8	Legacygerät

9	LPC-Controller

10	Microsoft ACPI-Konformers System

11	Microsoft virtueller Datenträgerenumerator

12	Microsoft-Systemverwaltungs-BIOS-Treiber

13	Numerischer Coprozessor

14	PCI-Bus

15	PCI-zu-PCI-Brücke

16	PCI-zu-PCI-Brücke

17	PCI-zu-PCI-Brücke

18	PnP-Softwaregeräte-Enumerator
	swenum.inf_amd64_ea7b19c04e7a8136\swenum.sys
19	Programmierbarer Interruptcontroller

20	Redirector-Bus für Remotedesktop-Geräte

21	SM-Bus-Controller

22	Systrem CMOS/Echtzeituhr

23	Systemlautsprecher

24	Systemzeitgeber

25	UMBus-Stamm-Busenumerator

Tastaturen
	HID-Tastatur


Tragbare Geräte
	USB_China2



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



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



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



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



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



6	USB-Massenspeichergeräte

7	USB-Root-Hub


8	USB-Root-Hub


9	USB-Root-Hub


10	USB-Root-Hub


11	USB-Root-Hub


12	USB-Verbundgeräte

Worksheet: Manual

wbCodesBeforeFrom cmd prompt.xlsm : https://app.box.com/s/hix9sjernnbdu9vk2oqgspg8z00t9u8j

**DocAElstein** · 02-08-2020, 07:34 PM

_____ Workbook: wbCodesBeforeFrom cmd prompt.xlsm ( Using Excel 2007 32 bit )

	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

	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























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










	C:\Windows\system32\DRIVERS\hidclass.sys
	C:\Windows\system32\DRIVERS\hidparse.sys
	C:\Windows\system32\DRIVERS\hidusb.sys

	C:\Windows\system32\DRIVERS\hidclass.sys
	C:\Windows\system32\DRIVERS\hidparse.sys
	C:\Windows\system32\DRIVERS\hidusb.sys


	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


	C:\Windows\system32\DRIVERS\atapi.sys
	C:\Windows\system32\DRIVERS\ataport.sys


	C:\Windows\system32\DRIVERS\atapi.sys
	C:\Windows\system32\DRIVERS\ataport.sys


	C:\Windows\system32\DRIVERS\atapi.sys
	C:\Windows\system32\DRIVERS\ataport.sys
	C:\Windows\system32\DRIVERS\intelide.sys
	C:\Windows\system32\DRIVERS\pciidx.sys


	C:\Windows\system32\DRIVERS\1394ohci.sys


	C:\Windows\system32\DRIVERS\disk.sys
	C:\Windows\system32\DRIVERS\EhStorClass.sys
	C:\Windows\system32\DRIVERS\partmgr.sys

	C:\Windows\system32\DRIVERS\disk.sys
	C:\Windows\system32\drivers\EhStorClass.sys
	C:\Windows\system32\drivers\partmgr.sys


	C:\Windows\system32\DRIVERS\mouclass.sys
	C:\Windows\system32\DRIVERS\mouhid.sys


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


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

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

	C:\Windows\system32\DRIVERS\ndistapi.sys
	C:\Windows\system32\DRIVERS\ndiswan.sys

	C:\Windows\system32\DRIVERS\ndistapi.sys
	C:\Windows\system32\DRIVERS\ndiswan.sys

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

	C:\Windows\system32\DRIVERS\ndistapi.sys
	C:\Windows\system32\DRIVERS\ndiswan.sys

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

	C:\Windows\system32\drivers\raspptp.swys

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


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

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

















	C:\Windows\system32\DRIVERS\spacedump.sys
	C:\Windows\system32\DRIVERS\spaceport.sys










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


	C:\Windows\system32\DRIVERS\dmk.sys
	C:\Windows\system32\DRIVERS\hdaudbus.sys
	C:\Windows\system32\DRIVERS\portcls.sys





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

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

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

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



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

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

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

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





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









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


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


		C:\Windows\system32\DRIVERS\UMDF\WpdFs.dll
	C:\Windows\system32\drivers\WpdUpFltr.sys
	C:\Windows\system32\DRIVERS\WUDFRd.sys


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

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

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

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

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

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

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

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

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

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

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

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

Worksheet: Manual

**DocAElstein** · 02-08-2020, 07:57 PM

In support of this post
http://www.excelfox.com/forum/showth...ll=1#post12124

Geräte-Manager Before : https://imgur.com/6IT2NC9
Attachment 2722

Audio Video und Game Controler 1.JPG : https://imgur.com/pxfQIX9
Audio Video und Game Controler 2.JPG : https://imgur.com/iUPViMn
Audioeingänge und -ausgänge 1.JPG : https://imgur.com/flkUEWD
Audioeingänge und -ausgänge 3.JPG : https://imgur.com/qnYMTjP
Audioeingänge und -ausgänge 2.JPG : https://imgur.com/ILJ1kBf
Computer.JPG : https://imgur.com/NuodN0E
Druckwarteshlange Fax.JPG : https://imgur.com/Uch955O
Druckwarteshlange Microsoft Print to PDF.JPG : https://imgur.com/KGTW8wq
Druckwarteshlange Microsoft XPS Document Writer.JPG : https://imgur.com/lRLmhZO
Druckwarteshlange OneNote.JPG : https://imgur.com/bjLMcGM
Druckwarteshlange Stammdruckwarteshlange.JPG : https://imgur.com/1Ndf2XB
DVD CD-ROM-Laufwerke.JPG : https://imgur.com/daGiajr
Eingabegeräte (Human Interface Decice) 1.JPG : https://imgur.com/GVQjnNv
Eingabegeräte (Human Interface Decice) 2.JPG : https://imgur.com/Fzeu0pS
Eingabegeräte (Human Interface Decice) 3.JPG : https://imgur.com/4TtEjHU
Eingabegeräte (Human Interface Decice) 4.JPG : https://imgur.com/Ng3DVE3
Eingabegeräte (Human Interface Decice) 5.JPG : https://imgur.com/wbFK11u
Eingabegeräte (Human Interface Decice) 6.JPG : https://imgur.com/DbSdltZ
Grafikkarten.JPG : https://imgur.com/dW6OOrI
IDE ATA ATAPI-Controller 1.JPG : https://imgur.com/1rVKfbC
IDE ATA ATAPI-Controller 2.JPG : https://imgur.com/2YI9jdL
IDE ATA ATAPI-Controller 3.JPG : https://imgur.com/L6HbNp4
IEE 1394-Hostcontroller.JPG : https://imgur.com/IwO5pbG
Laufwerk 1.JPG : https://imgur.com/8KyZRiK
Laufwerk 2.JPG : https://imgur.com/eDvgnMH
Mäuse und andere Zeigegeräte.JPG : https://imgur.com/XFl9PcA
Monitore.JPG : https://imgur.com/VAayLlT
Netzwerkadaptor 1.JPG : https://imgur.com/2NiovPn
Netzwerkadaptor 2.JPG : https://imgur.com/xP80QlV
Netzwerkadaptor 3.JPG : https://imgur.com/IpFWH0x
Netzwerkadaptor 4.JPG : https://imgur.com/8pVcZ8M
Netzwerkadaptor 5.JPG : https://imgur.com/S3W35Z3
Netzwerkadaptor 6.JPG : https://imgur.com/lUZDGcP
Netzwerkadaptor 7.JPG : https://imgur.com/dBFnOFD
Netzwerkadaptor 8.JPG : https://imgur.com/rnxwMoN
Netzwerkadaptor 9.JPG : https://imgur.com/WQYsDDk
Prozessoren 1.JPG : https://imgur.com/9B7pMqH
Prozessoren 2.JPG : https://imgur.com/mvfLvOG
Softwaregeräte 1.JPG : https://imgur.com/us8XDDQ
Softwaregeräte 2.JPG : https://imgur.com/q15BRkP
Softwaregeräte 3.JPG : https://imgur.com/AdDBMaz
Softwaregeräte 4.JPG : https://imgur.com/Xswu3mW
Softwaregeräte 5.JPG : https://imgur.com/8YiYQFL
Softwaregeräte 6.JPG : https://imgur.com/RcxBE0o
Softwaregeräte 7.JPG : https://imgur.com/lvXaM9Z
Speichercontroller.JPG : https://imgur.com/IZcPqew
Systemgeräte 1.JPG : https://imgur.com/axWbdSx
Systemgeräte 2.JPG : https://imgur.com/wArJPoq
Systemgeräte 3.JPG : https://imgur.com/i778VGg
Systemgeräte 4.JPG : https://imgur.com/khBWz5F
Systemgeräte 5.JPG : https://imgur.com/sRNIUqw
Systemgeräte 6.JPG : https://imgur.com/gXmMoyM
Systemgeräte 7.JPG : https://imgur.com/TzOrMQb
Systemgeräte 8.JPG : https://imgur.com/CJecHST
Systemgeräte 9.JPG : https://imgur.com/FwH9rrd
Systemgeräte 10.JPG : https://imgur.com/urqGHV8
Systemgeräte 11.JPG : https://imgur.com/Y11hbdk
Systemgeräte 12.JPG : https://imgur.com/ULwFr7T
Systemgeräte 13.JPG : https://imgur.com/218r0g0
Systemgeräte 14.JPG : https://imgur.com/Nr8O15k
Systemgeräte 15.JPG : https://imgur.com/o9sMnlQ
Systemgeräte 16.JPG : https://imgur.com/B7PRKDp
Systemgeräte 17.JPG : https://imgur.com/MMkwaen
Systemgeräte 18.JPG : https://imgur.com/6gE2Afq
Systemgeräte 19.JPG : https://imgur.com/Y7UcvGE
Systemgeräte 20.JPG : https://imgur.com/dVtp9FW
Systemgeräte 21.JPG : https://imgur.com/NHk0epf
Systemgeräte 22.JPG : https://imgur.com/wUN3To1
Systemgeräte 23.JPG : https://imgur.com/uJg3OMi
Systemgeräte 24.JPG : https://imgur.com/9MpF7nk
Systemgeräte 25.JPG : https://imgur.com/cZ4x8Jf
Tastaturen.JPG : https://imgur.com/2eGpdYE
Tragbare Geräte.JPG : https://imgur.com/sLjH1UH
USB-Controller 1.JPG : https://imgur.com/0LtyydZ
USB-Controller 2.JPG : https://imgur.com/ZBkmxaS
USB-Controller 3.JPG : https://imgur.com/ToQj8d8
USB-Controller 4.JPG : https://imgur.com/rGFUyhA
USB-Controller 5.JPG : https://imgur.com/bSYZSOM
USB-Controller 6.JPG : https://imgur.com/w7wk6G5
USB-Controller 7.JPG : https://imgur.com/eGPgFxa
USB-Controller 8.JPG : https://imgur.com/XAEXWmk
USB-Controller 9.JPG : https://imgur.com/GV2mhmg
USB-Controller 10.JPG : https://imgur.com/a3j29CH
USB-Controller 11.JPG : https://imgur.com/KykO1mb

Device Manager Before.JPG : https://imgur.com/DfI49fZ
Geraete Manager Before.xlsm : https://app.box.com/s/sef9l9cr9df7ul7i22cno49uqcqecte0

wbCodesBeforeFrom cmd prompt.xlsm : https://app.box.com/s/hix9sjernnbdu9vk2oqgspg8z00t9u8j

**DocAElstein** · 02-08-2020, 07:57 PM

In support of this post
http://www.excelfox.com/forum/showth...ll=1#post12124

Geräte-Manager Before : https://imgur.com/6IT2NC9
Attachment 2722

Code:

				
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		
Audioeingänge und - ausgänge				
	47PL3605h(High definition Audio-Gerät			
				
	Digitalaudio (S/PDIF) (2 - High Definition Audio.Gerät)			
				
	Digitalaudio (S/PDIF) (2 - High Definition Audio.Gerät)			
				
Computer				
	ACIPx64-basierter PC			
				
Druckwarteshlangen				
	Fax			
				
	Micrtosoft print to PDF			
				
	Microsoft XPS Document Writer			
				
	OneNote			
				
	Stammdruckwarteshlange			
				
DVD/CD-ROM-Laufwerke				
	TSSTcorpDVD-ROM SH-D163C ATA Device			
			C:\Windows\system32\DRIVERS\cdrom.sys	
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	
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		
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	
IEEE 1394-Hostcontroller				
	OHCI-konformer texas Instruments1394-Hostcontroller			
			C:\Windows\system32\DRIVERS\1394ohci.sys	
Laufwerk				
	General UDisk USB Device			
			C:\Windows\system32\DRIVERS\disk.sys	
			C:\Windows\system32\DRIVERS\EhStorClass.sys	
			C:\Windows\system32\DRIVERS\partmgr.sys	
	SAMSUNG HD253GJ ATA Device			
			C:\Windows\system32\DRIVERS\disk.sys	
			C:\Windows\system32\drivers\EhStorClass.sys	
			C:\Windows\system32\drivers\partmgr.sys	
Mäuse und andere Zeigegeräte				
	HID-konforme Mause			
			C:\Windows\system32\DRIVERS\mouclass.sys	
			C:\Windows\system32\DRIVERS\mouhid.sys	
Monitore				
	PnP-Monitore (Standard)			
			C:\Windows\system32\DRIVERS\monitor.sys	
Netzwerkadaptor				
	Realitek PCIe GBE Family Controller			
			C:\Windows\system32\DRIVERS\rt640x64.sys	
	WAN Miniport (IKEv2)			
			C:\Windows\system32\drivers\AgileVpn.sys	
	WAN Miniport (IP)			
			C:\Windows\system32\DRIVERS\ndistapi.sys	
			C:\Windows\system32\DRIVERS\ndiswan.sys	
	WAN Miniport (IPv6)			
			C:\Windows\system32\DRIVERS\ndistapi.sys	
			C:\Windows\system32\DRIVERS\ndiswan.sys	
	WAN Miniport (L2DP)			
			C:\Windows\system32\DRIVERS\rasl2tp.sys	
	WAN Miniport (Network Monitor)			
			C:\Windows\system32\DRIVERS\ndistapi.sys	
			C:\Windows\system32\DRIVERS\ndiswan.sys	
	WAN Miniport (PPPOE)			
			C:\Windows\system32\DRIVERS\rasppppoe.sys	
	WAN Miniport (PPTP)			
			C:\Windows\system32\drivers\raspptp.swys	
	WAN Miniport (SSTP)			
			C:\Windows\system32\DRIVERS\rassstptp.sys	
Prozessoren				
	Intel(R) Core(TM)2 Duo CPU   E750 @ 2.93GHz			
			C:\Windows\system32\DRIVERS\intelppm.sys	
	Intel(R) Core(TM)2 Duo CPU   E750 @ 2.93GHz			
			C:\Windows\system32\DRIVERS\intelppm.sys	
Softwaregeräte				
	Brother DCP-1610W series [e89eb44818d]			
				
	ELSTON-PC: elston:			
				
	HPB6102A (HP Officejet Pro 8720)			
				
	Microsoft Device Asssociation Root Enumerator			
				
	Microsoft GS Wavetable Synthesis			
				
	Microsoft RRAS Root Enumerator			
				
	NPIA27BB4 (HP Laserjet 200 colorMFP M275nw)			
				
Speichercontroller				
	Microsoft-Controller für Speicherplätze			
			C:\Windows\system32\DRIVERS\spacedump.sys	
			C:\Windows\system32\DRIVERS\spaceport.sys	
Systemgeräte				
1	ACIP-Schalter			
				
2	Busenumerator für Verbundgeräte			
	                                                                                                                      compositebus.inf_amd64_bcb89b3386563bd7\CompositeBus.sys			
3	CPU-zu-EA-Controller			
				
4	DMA-Controller			
				
5	Enumerator für virtuelle NDIS-Nertzwerkadaptor			
			C:\Windows\system32\drivers\NdisVirtualBus.sys	
6	High Definition Audio Controller			
				
			C:\Windows\system32\DRIVERS\dmk.sys	
			C:\Windows\system32\DRIVERS\hdaudbus.sys	
			C:\Windows\system32\DRIVERS\portcls.sys	
7	Hochpräzisionsereigniszeitgeber			
				
8	Legacygerät			
				
9	LPC-Controller			
			C:\Windows\system32\DRIVERS\msisadrv.sys	
10	Microsoft ACPI-Konformers System			
			C:\Windows\system32\DRIVERS\acpi.sys	
11	Microsoft  virtueller Datenträgerenumerator			
			C:\Windows\system32\DRIVERS\vdrvroot.sys	
12	Microsoft-Systemverwaltungs-BIOS-Treiber			
			C:\Windows\system32\DRIVERS\mssmbios.sys	
13	Numerischer Coprozessor			
				
14	PCI-Bus			
			C:\Windows\system32\DRIVERS\pci.sys	
15	PCI-zu-PCI-Brücke			
			C:\Windows\system32\DRIVERS\pci.sys	
16	PCI-zu-PCI-Brücke			
			C:\Windows\system32\DRIVERS\pci.sys	
17	PCI-zu-PCI-Brücke			
			C:\Windows\system32\DRIVERS\pci.sys	
18	PnP-Softwaregeräte-Enumerator			
	                                                                                                                                      swenum.inf_amd64_ea7b19c04e7a8136\swenum.sys			
19	Programmierbarer Interruptcontroller			
				
20	Redirector-Bus für Remotedesktop-Geräte			
			C:\Windows\system32\DRIVERS\rdpbus.sys	
21	SM-Bus-Controller			
				
22	Systrem CMOS/Echtzeituhr			
				
23	Systemlautsprecher			
				
24	Systemzeitgeber			
				
25	UMBus-Stamm-Busenumerator			
			C:\Windows\system32\DRIVERS\umbus.sys	
Tastaturen				
	HID-Tastatur			
			C:\Windows\system32\DRIVERS\kbdclass.sys	
			C:\Windows\system32\DRIVERS\kbdhid.sys	
Tragbare Geräte				
	USB_China2			
				C:\Windows\system32\DRIVERS\UMDF\WpdFs.dll
			C:\Windows\system32\drivers\WpdUpFltr.sys	
			C:\Windows\system32\DRIVERS\WUDFRd.sys	
USB-Controller				
1	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	
2	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	
3	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	
4	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	
5	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	
6	USB-Massenspeichergeräte			
			C:\Windows\system32\drivers\USBSTOR.SYS	
7	USB-Root-Hub			
			C:\Windows\system32\drivers\usbd.sys	
			C:\Windows\system32\drivers\usbhub.sys	
8	USB-Root-Hub			
			C:\Windows\system32\drivers\usbd.sys	
			C:\Windows\system32\drivers\usbhub.sys	
9	USB-Root-Hub			
			C:\Windows\system32\drivers\usbd.sys	
			C:\Windows\system32\drivers\usbhub.sys	
10	USB-Root-Hub			
			C:\Windows\system32\drivers\usbd.sys	
			C:\Windows\system32\drivers\usbhub.sys	
11	USB-Root-Hub			
			C:\Windows\system32\drivers\usbd.sys	
			C:\Windows\system32\drivers\usbhub.sys	
12	USB-Verbundgeräte			
			C:\Windows\system32\drivers\usbccgp.sys	
				
				
				
				
				
				
				
			120

Device Manager Before.JPG : https://imgur.com/DfI49fZ
Geraete Manager Before.xlsm : https://app.box.com/s/sef9l9cr9df7ul7i22cno49uqcqecte0

wbCodesBeforeFrom cmd prompt.xlsm : https://app.box.com/s/hix9sjernnbdu9vk2oqgspg8z00t9u8j

**DocAElstein** · 02-08-2020, 11:26 PM

In support of this post
http://www.excelfox.com/forum/showth...ll=1#post12124

Geräte-Manager Before : https://imgur.com/6IT2NC9
Attachment 2722

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
Audioeingänge und - ausgänge
47PL3605h(High definition Audio-Gerät

Digitalaudio (S/PDIF) (2 - High Definition Audio.Gerät)

Digitalaudio (S/PDIF) (2 - High Definition Audio.Gerät)

Computer
ACIPx64-basierter PC

Druckwarteshlangen
Fax

Micrtosoft print to PDF

Microsoft XPS Document Writer

OneNote

Stammdruckwarteshlange

DVD/CD-ROM-Laufwerke
TSSTcorpDVD-ROM SH-D163C ATA Device
C:\Windows\system32\DRIVERS\cdrom.sys
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
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
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
IEEE 1394-Hostcontroller
OHCI-konformer texas Instruments1394-Hostcontroller
C:\Windows\system32\DRIVERS\1394ohci.sys
Laufwerk
General UDisk USB Device
C:\Windows\system32\DRIVERS\disk.sys
C:\Windows\system32\DRIVERS\EhStorClass.sys
C:\Windows\system32\DRIVERS\partmgr.sys
SAMSUNG HD253GJ ATA Device
C:\Windows\system32\DRIVERS\disk.sys
C:\Windows\system32\drivers\EhStorClass.sys
C:\Windows\system32\drivers\partmgr.sys
Mäuse und andere Zeigegeräte
HID-konforme Mause
C:\Windows\system32\DRIVERS\mouclass.sys
C:\Windows\system32\DRIVERS\mouhid.sys
Monitore
PnP-Monitore (Standard)
C:\Windows\system32\DRIVERS\monitor.sys
Netzwerkadaptor
Realitek PCIe GBE Family Controller
C:\Windows\system32\DRIVERS\rt640x64.sys
WAN Miniport (IKEv2)
C:\Windows\system32\drivers\AgileVpn.sys
WAN Miniport (IP)
C:\Windows\system32\DRIVERS\ndistapi.sys
C:\Windows\system32\DRIVERS\ndiswan.sys
WAN Miniport (IPv6)
C:\Windows\system32\DRIVERS\ndistapi.sys
C:\Windows\system32\DRIVERS\ndiswan.sys
WAN Miniport (L2DP)
C:\Windows\system32\DRIVERS\rasl2tp.sys
WAN Miniport (Network Monitor)
C:\Windows\system32\DRIVERS\ndistapi.sys
C:\Windows\system32\DRIVERS\ndiswan.sys
WAN Miniport (PPPOE)
C:\Windows\system32\DRIVERS\rasppppoe.sys
WAN Miniport (PPTP)
C:\Windows\system32\drivers\raspptp.swys
WAN Miniport (SSTP)
C:\Windows\system32\DRIVERS\rassstptp.sys
Prozessoren
Intel(R) Core(TM)2 Duo CPU E750 @ 2.93GHz
C:\Windows\system32\DRIVERS\intelppm.sys
Intel(R) Core(TM)2 Duo CPU E750 @ 2.93GHz
C:\Windows\system32\DRIVERS\intelppm.sys
Softwaregeräte
Brother DCP-1610W series [e89eb44818d]

ELSTON-PC: elston:

HPB6102A (HP Officejet Pro 8720)

Microsoft Device Asssociation Root Enumerator

Microsoft GS Wavetable Synthesis

Microsoft RRAS Root Enumerator

NPIA27BB4 (HP Laserjet 200 colorMFP M275nw)

Speichercontroller
Microsoft-Controller für Speicherplätze
C:\Windows\system32\DRIVERS\spacedump.sys
C:\Windows\system32\DRIVERS\spaceport.sys
Systemgeräte
1 ACIP-Schalter

2 Busenumerator für Verbundgeräte
compositebus.inf_amd64_bcb89b3386563bd7\CompositeB us.sys
3 CPU-zu-EA-Controller

4 DMA-Controller

5 Enumerator für virtuelle NDIS-Nertzwerkadaptor
C:\Windows\system32\drivers\NdisVirtualBus.sys
6 High Definition Audio Controller

C:\Windows\system32\DRIVERS\dmk.sys
C:\Windows\system32\DRIVERS\hdaudbus.sys
C:\Windows\system32\DRIVERS\portcls.sys
7 Hochpräzisionsereigniszeitgeber

8 Legacygerät

9 LPC-Controller
C:\Windows\system32\DRIVERS\msisadrv.sys
10 Microsoft ACPI-Konformers System
C:\Windows\system32\DRIVERS\acpi.sys
11 Microsoft virtueller Datenträgerenumerator
C:\Windows\system32\DRIVERS\vdrvroot.sys
12 Microsoft-Systemverwaltungs-BIOS-Treiber
C:\Windows\system32\DRIVERS\mssmbios.sys
13 Numerischer Coprozessor

14 PCI-Bus
C:\Windows\system32\DRIVERS\pci.sys
15 PCI-zu-PCI-Brücke
C:\Windows\system32\DRIVERS\pci.sys
16 PCI-zu-PCI-Brücke
C:\Windows\system32\DRIVERS\pci.sys
17 PCI-zu-PCI-Brücke
C:\Windows\system32\DRIVERS\pci.sys
18 PnP-Softwaregeräte-Enumerator
swenum.inf_amd64_ea7b19c04e7a8136\swenum.sys
19 Programmierbarer Interruptcontroller

20 Redirector-Bus für Remotedesktop-Geräte
C:\Windows\system32\DRIVERS\rdpbus.sys
21 SM-Bus-Controller

22 Systrem CMOS/Echtzeituhr

23 Systemlautsprecher

24 Systemzeitgeber

25 UMBus-Stamm-Busenumerator
C:\Windows\system32\DRIVERS\umbus.sys
Tastaturen
HID-Tastatur
C:\Windows\system32\DRIVERS\kbdclass.sys
C:\Windows\system32\DRIVERS\kbdhid.sys
Tragbare Geräte
USB_China2
C:\Windows\system32\DRIVERS\UMDF\WpdFs.dll
C:\Windows\system32\drivers\WpdUpFltr.sys
C:\Windows\system32\DRIVERS\WUDFRd.sys
USB-Controller
1 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
2 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
3 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
4 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
5 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
6 USB-Massenspeichergeräte
C:\Windows\system32\drivers\USBSTOR.SYS
7 USB-Root-Hub
C:\Windows\system32\drivers\usbd.sys
C:\Windows\system32\drivers\usbhub.sys
8 USB-Root-Hub
C:\Windows\system32\drivers\usbd.sys
C:\Windows\system32\drivers\usbhub.sys
9 USB-Root-Hub
C:\Windows\system32\drivers\usbd.sys
C:\Windows\system32\drivers\usbhub.sys
10 USB-Root-Hub
C:\Windows\system32\drivers\usbd.sys
C:\Windows\system32\drivers\usbhub.sys
11 USB-Root-Hub
C:\Windows\system32\drivers\usbd.sys
C:\Windows\system32\drivers\usbhub.sys
12 USB-Verbundgeräte
C:\Windows\system32\drivers\usbccgp.sys

120

**DocAElstein** · 02-11-2020, 11:50 PM

In support of this Post
http://www.excelfox.com/forum/showth...ll=1#post12142

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

Double Driver Backup Non Microsoft

	EG41MFT-US2H 09.02.2020 14-24-41

		Display

			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

		Printer

			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

Worksheet: DDNonMicrosoftBefore

wbCodesBeforeFromDoubleDriver.xlsm : https://app.box.com/s/c5cxiz6rbv8frupedm26px4k51ybz7n0

**DocAElstein** · 02-12-2020, 12:31 AM

In support of this Post
http://www.excelfox.com/forum/showth...ll=1#post12142

Code:

		
		
PrintQueue		
		
	Local Print Queue	
	restore.ini	
	printqueue.inf	
		
USB		
		
	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	
		
CDROM		
		
	CD-ROM Drive	
	restore.ini	
	cdrom.inf	
	cdrom.sys	
		
Computer		
		
	ACPI x64-based PC	
	restore.ini	
	hal.inf	
		
DiskDrive		
		
	Disk drive	
	restore.ini	
	disk.inf	
	disk.sys	
		
Display		
		
	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	
		
HDC		
		
	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	
		
Keyboard		
		
	HID Keyboard Device	
	restore.ini	
	keyboard.inf	
	i8042prt.sys	
	kbdclass.sys	
	kbdhid.sys	
		
MEDIA		
		
	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	
		
Monitor		
		
	Generic PnP Monitor	
	restore.ini	
	monitor.inf	
	monitor.sys	
		
	Generic Non-PnP Monitor	
	restore.ini	
	monitor.inf	
	monitor.sys	
		
Mouse		
		
	HID-compliant mouse	
	restore.ini	
	msmouse.inf	
	mouclass.sys	
	sermouse.sys	
	mouhid.sys	
		
Net		
		
	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	
		
Printer		
		
	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
		
SCSIAdapter		
		
	Microsoft Storage Spaces Controller	
	restore.ini	
	spaceport.inf	
	spaceport.sys	
	spacedump.sys	
		
System		
		
	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	
		
Processor		
		
	Intel Processor	
	restore.ini	
	cpu.inf	
	processr.sys	
	intelppm.sys	
	amdk8.sys	
	amdppm.sys	
		
VolumeSnapshot		
		
	Generic volume shadow copy	
	restore.ini	
	volsnap.inf	
		
SoftwareDevice		
		
	Generic software device	
	restore.ini	
	c_swdevice.inf	
		
1394		
		
	Texas Instruments 1394 OHCI Compliant Host Controller	
	restore.ini	
	1394.inf	
	1394ohci.sys	
		
Image		
		
	WSD-Scandienst	
	restore.ini	
	wsdscdrv.inf	
	WSDScDrv.dll	
		
Volume		
		
	Volume	
	restore.ini	
	volume.inf	
	volume.sys	
		
HIDClass		
		
	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	
		
AudioEndpoint		
		
	Audio Endpoint	
	restore.ini	
	audioendpoint.inf	
		
WSDPrintDevice		
		
	WSD Print Device	
	restore.ini	
	wsdprint.inf	
	wsdprint.sys	
		
WPD		
		
	WPD-Dateisystem-Volumetreiber	
	restore.ini	
	wpdfs.inf	
	wpdfs.dll

wbCodesBeforeFromDoubleDriver.xlsm : https://app.box.com/s/c5cxiz6rbv8frupedm26px4k51ybz7n0

**DocAElstein** · 02-16-2020, 06:51 PM

In Support of this Post question
2020-02-15 15:08:06 https://excelribbon.tips.net/T009046...een_Dates.html Karim K.

Determining Differences Between Dates

From Allen Wyatt, here https://excelribbon.tips.net/T009046...een_Dates.html

….. When you are programming Excel macros, you should know that dates are stored internally, within variables, as serial numbers. The serial number represents the number of days elapsed since a starting "base date," specifically since 1 January 100. This means that you can perform math with the serial numbers, if desired. You can, for instance, find the number of days between two dates by simply subtracting the dates from each other.

If you want to get fancier in your date calculations, you can use the DateDiff function. This function allows you, for instance, to determine the number of weeks or months between two dates. In order to use the function to find this type of information, you would do as follows:

Code:

iNumWeeks = DateDiff("ww", dFirstDate, dSecondDate)
iNumMonths = DateDiff("m", dFirstDate, dSecondDate)

The first line determines the number of weeks between the two dates, and the second determines the number of months between them.
Remember that the DateDiff function is a macro (VBA) function, not a worksheet function. Excel handles a range of dates in worksheets that begin with January 1, 1900. In VBA, however, dates can begin (as already noted) in the year 100. That means that macros can handle a much larger range of dates, including dates prior to those handled natively by Excel……………..

Example: : User inputs "2/15/2019" in cell (C4) - The next day it shows "1 Day/s" and so on.

The following coding must go in the worksheets code module of the worksheet of interest:
_1 Right Click Tab _2 Select Show Code or _ 3 Double Click on worksheet in VB Editor project Explorer .JPG : https://imgur.com/1xcWkQJ , https://imgur.com/oWS0uZ4
Attachment 2748 Attachment 2749

In first worksheet Code Module

Code:

Option Explicit ' https://excelribbon.tips.net/T009046_Determining_Differences_Between_Dates.html  '   https://docs.microsoft.com/de-de/office/vba/language/reference/user-interface-help/datediff-function
Public Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 3 Then
    Dim rngC As Range: Set rngC = Me.Range("C2:C" & (Me.UsedRange.Row + Me.UsedRange.Rows.Count - 1) & "") ' (Bottom left of Usedrange + Row count in UsedRange) - 1 will give us the last row
    Dim rngStr As Range
        For Each rngStr In rngC
            Debug.Print rngStr.Value ' From VB Editor, Hit keys  Ctrl + g  to see the immediate window
            If rngStr <> "" Then
            Dim Vl As String: Let Vl = rngStr.Value
                If Len(Vl) < 8 Then MsgBox Prompt:=Vl & " is too short for a date": GoTo Nxt
                If Len(Vl) - Len(Replace(Vl, "/", "")) <> 2 Then MsgBox Prompt:="Don't have 2 ""/""s in " & Vl: GoTo Nxt
            Dim Dey As String, Munf As String, Jear As String
            Dim strSplt() As String: Let strSplt() = Split(Vl, "/", 3, vbBinaryCompare) ' https://imgur.com/1xcWkQJ
             Let Dey = strSplt(1): Munf = strSplt(0): Jear = strSplt(2)
            Dim Dte As Date, strDte As String, LngDte As Long
             Let strDte = Format(Dey & " " & Munf & " " & Jear, "dd mmmm yyyy"): Debug.Print strDte
             Let Dte = CDate(strDte)
             Let strDte = Format(Dey & " " & Munf & " " & Jear, "dd" & ", " & "mmmm" & ",  " & "yyyy"): Debug.Print strDte
             Let LngDte = CLng(Dte) ' Allen Wyatt: When you are programming Excel macros, you should know that dates are stored internally, within variables, as serial numbers. The serial number represents the number of days elapsed since a starting "base date," specifically since 1 January 100. This means that you can perform math with the serial numbers, if desired. You can, for instance, find the number of days between two dates by simply subtracting the dates from each other.
            Dim LngNow As Long: Let LngNow = CLng(Now())
            ' https://excelribbon.tips.net/T009046_Determining_Differences_Between_Dates.html  '  https://docs.microsoft.com/de-de/office/vba/language/reference/user-interface-help/datediff-function
            Dim iNumDays As Long, iNumWeeks As Long, iNumMonths As Long
             Let iNumDays = DateDiff("d", LngDte, LngNow) ' = LngNow-LngDte
             Let iNumWeeks = DateDiff("w", LngDte, LngNow)
             Let iNumMonths = DateDiff("m", LngDte, LngNow)
             Let Application.EnableEvents = False
             Let rngStr.Offset(0, 1).Value = iNumDays & " Days,  " & iNumWeeks & " Weeks,   and " & iNumMonths & " Months."
             Let rngStr.Offset(0, 2).Value = strDte
             Let Application.EnableEvents = True
            Else ' case empty cell
            End If
Nxt:    Next rngStr
    Else ' No change in column 3 ( "C" )
    End If

Me.Columns.AutoFit
End Sub

Note:
You may need to adjust the coding a bit with a +1 or -1 somewhere to get the day count output exactly as you want it

The above macro will start automatically when you add a date into column “C” , provided it has this sort of format
2/15/2020
( Month/Day/Year )

The following additional macro, will ensure that the worksheet is updated when the workbook is opened

Macro in ThisWorkbook code module

Code:

Private Sub Workbook_Open()
 Call Tabelle1.Worksheet_Change(Worksheets.Item(1).Range("C2"))
End Sub

The above code module and coding therein can be seen by double clicking on the ThisWorkbook code module in the VB Editor explorer:
Double Click on ThisWorkbook in VB Editor Explorer.jpg : https://imgur.com/Kls33SD
Attachment 2747

Note, In order to call our macro Public Sub Worksheet_Change(ByVal Target As Range) in this way, we have changed the more typically seen , default option of Private to Public in the first macro in the worksheets code module

Here is a typical output
_____ Workbook: KarimKAllenWyattDateDifferences.xlsm ( Using Excel 2007 32 bit )

_Row\^Col	C	D	E
3
4	2/15/2020	2 Days, 0 Weeks, and 0 Months.	15, Februar, 2020
5	1/15/2020	33 Days, 4 Weeks, and 1 Months.	15, Januar, 2020
6	6
7	3/12/2019	342 Days, 48 Weeks, and 11 Months.	12, März, 2019
8	2/16/2020	1 Days, 0 Weeks, and 0 Months.	16, Februar, 2020
9	z

Worksheet: Tabelle1

KarimKAllenWyattDateDifferences.xlsm : https://app.box.com/s/ti0n1wj62hcd2qmhcg5kiqle1sya79ux

**DocAElstein** · 02-16-2020, 10:07 PM

In support of this postpost
http://www.excelfox.com/forum/showth...ce-Excel/page8
http://www.excelfox.com/forum/showth...age8#post12252
( see also here : http://www.excelfox.com/forum/showth...ll=1#post12147
http://www.excelfox.com/forum/showth...ll=1#post12148 )

First a "VBA" arrays type macro to count the total number of files with their extensions , then a "spreadsheet" type equivalent extended also to look at the color of the cells

Code:

Rem 1 Worksheets info
Dim Ws As Worksheet: Set Ws = Me
Dim Rng As Range: Set Rng = Ws.Range("D2:F264")
Dim arrFiles() As Variant: Let arrFiles() = Rng.Value2
Rem 2 File extension types
Dim Ddl As Long, Sys As Long, Bin As Long, Cpa As Long, Vp As Long, Els As Long
Rem 3 Looping
Dim ClCnt As Long, RwCnt As Long
    For RwCnt = 1 To UBound(arrFiles(), 1)
        For ClCnt = 1 To UBound(arrFiles(), 2)
            If arrFiles(RwCnt, ClCnt) = "" Then
            ' Empty cell, so do nothing
            Else ' Time to look at cell value
                If Left(arrFiles(RwCnt, ClCnt), 3) = "C:\" And InStr(4, arrFiles(RwCnt, ClCnt), ".", vbBinaryCompare) > 1 Then ' use some criteria to check we have a file path
                ' Get the extension
                Dim Xtn As String
                 Let Xtn = Mid(arrFiles(RwCnt, ClCnt), (InStr(4, arrFiles(RwCnt, ClCnt), ".", vbBinaryCompare) + 1))
                    Select Case Xtn
                     Case "sys", "SYS"
                      Let Sys = Sys + 1
                     Case "dll"
                      Let Ddl = Ddl + 1
                     Case "bin"
                      Let Bin = Bin + 1
                     Case "cpa"
                      Let Cpa = Cpa + 1
                     Case "vp"
                      Let Vp = Vp + 1
                     Case Else
                      Debug.Print "Case Else   " & arrFiles(RwCnt, ClCnt)
                      Let Els = Els + 1
                    End Select
                Else ' not a file path
                End If
            End If
        Next ClCnt
    Next RwCnt
Rem 4 output

Debug.Print "sys   " & Sys
Debug.Print "ddl   " & Ddl
Debug.Print "bin   " & Bin
Debug.Print "cpa   " & Cpa
Debug.Print "vp   " & Vp
Debug.Print "els   " & Els

End Sub


Sub WotsANormalCellColor()
 Let Range("A1").Value = "AnyText"
 Debug.Print Range("A1").Font.Color & "   " & Range("A1").Font.ColorIndex '  we seee that   Color  for black or automatic is  0    ColorIndex  for black is 1  for automatic is   -4105
End Sub




' The next code and the one  in the next post is the spreadsheet type equivalent extended also to look at the color of the cells
Sub FileTypesHere()
Rem 1 Worksheets info
Dim Ws As Worksheet: Set Ws = Me
Dim Rng As Range: Set Rng = Ws.Range("D2:F264")
'Dim arrFiles() As Variant: Let arrFiles() = Rng.Value2
Rem 2 File extension types
Dim Ddl As Long, Sys As Long, Bin As Long, Cpa As Long, Vp As Long, Els As Long
Dim Ddl2 As Long, Sys2 As Long, Bin2 As Long, Cpa2 As Long, Vp2 As Long, Els2 As Long
Rem 3 Looping
'Dim ClCnt As Long, RwCnt As Long
Dim RngStr As Range ' a single cell to use as a stear element in the For Next loop
    For Each RngStr In Rng
'    For RwCnt = 1 To UBound(arrFiles(), 1)
'        For ClCnt = 1 To UBound(arrFiles(), 2)
            'If arrFiles(RwCnt, ClCnt) = "" Then
            If RngStr.Value = "" Then
            ' Empty cell, so do nothing
            Else ' Time to look at cell value
                'If Left(arrFiles(RwCnt, ClCnt), 3) = "C:\" And InStr(4, arrFiles(RwCnt, ClCnt), ".", vbBinaryCompare) > 1 Then ' use some criteria to check we have a file path
                If Left(RngStr.Value, 3) = "C:\" And InStr(4, RngStr.Value, ".", vbBinaryCompare) > 1 Then ' use some criteria to check we have a file path
                ' Get the extension
                Dim Xtn As String
                'Let Xtn = Mid(arrFiles(RwCnt, ClCnt), (InStr(4, arrFiles(RwCnt, ClCnt), ".", vbBinaryCompare) + 1))
                 Let Xtn = Mid(RngStr.Value, (InStr(4, RngStr.Value, ".", vbBinaryCompare) + 1))
                    Select Case Xtn
                     Case "sys", "SYS"
                      Let Sys = Sys + 1: If RngStr.Font.Color <> 0 Then Let Sys2 = Sys2 + 1
                     Case "dll"
                      Let Ddl = Ddl + 1: If RngStr.Font.Color <> 0 Then Let Ddl2 = Ddl2 + 1
                     Case "bin"
                      Let Bin = Bin + 1:: If RngStr.Font.Color <> 0 Then Let Bin2 = Bin2 + 1
                     Case "cpa"
                      Let Cpa = Cpa + 1: If RngStr.Font.Color <> 0 Then Let Cpa2 = Cpa2 + 1
                     Case "vp"
                      Let Vp = Vp + 1: If RngStr.Font.Color <> 0 Then Let Vp2 = Vp2 + 1
                     Case Else
                      Debug.Print "Case Else   " & RngStr.Value
                      Let Els = Els + 1: If RngStr.Font.Color <> 0 Then Let Els2 = Els2 + 1
                    End Select
                Else ' not a file path
                End If
            End If
'        Next ClCnt
'    Next RwCnt
    Next RngStr
Rem 4 output

Debug.Print "sys   " & Sys & " (" & Sys2 & ")"
Debug.Print "dll   " & Ddl & " (" & Ddl2 & ")"
Debug.Print "bin   " & Bin & " (" & Bin2 & ")"
Debug.Print "cpa   " & Cpa & " (" & Cpa2 & ")"
Debug.Print "vp   " & Vp & " (" & Vp2 & ")"
Debug.Print "els   " & Els & " (" & Els2 & ")"

End Sub