Windows 10 and Office Excel

[DocAElstein]

Comparison of the different back ups

This is an attempt to briefly compare and summarise what the different ways have given us.

It is based on the explorer type folder output looked at in a summary file
ExplorerViewDriversBefore.xlsm : https://app.box.com/s/nixu8i6jmw802rdpen9lsfykrf15vm24

Double Driver All
This gave us finally a Folder, EG41MFT-US2H 09.02.2020 17-50-05 ,
Apply the following macro we can see what is in the first level …_

Sub ColumnsE()
 Columns("E:E").SpecialCells(xlCellTypeConstants, xlTextValues + xlNumbers).Copy
 Paste Destination:=Range("E680")
End Sub

_.. which is 26 Folders with the following names, ( and I have added the number of Sub folders at the next level )

PrintQueue (1)
USB (8)
CDROM (1)
Computer (1)
DiskDrive (1)
Display (1)
HDC (2)
Keyboard (1)
MEDIA (6)
Monitor (2)
Mouse (1)
Net (10)
Printer (3)
SCSIAdapter (1)
System (29)
Processor (1)
VolumeSnapshot (1)
SoftwareDevice (1)
1394 (1)
Image (1)
Volume (1)
HIDClass (4)
AudioEndpoint (1)
WSDPrintDevice (1)
WPD (1)

The file types are of these sorts
.ini
.inf
.sys
.dll
.xml
.bag
.cab
.js
.gdl
.cat
.gpd
.exe

The number of sub Folders at the next 2 levels is approx 161


_.__________

If we look at the manually produced results from the device manager we see 20 entries
Audio, Video und Gamecontroller (2)
Audioeingänge und – ausgänge (3)
Computer (1)
Druckwarteshlangen (5)
DVD/CD-ROM-Laufwerke (1)
Eingabegeräte (Human Interface Device) (6)
Grafikkarten (1)
IDE ATA/ATAPI-Controller (3)
IEEE 1394-Hostcontroller (1)
Laufwerk (2)
Mäuse und andere Zeigegeräte (1)
Monitore (1)
Netzwerkadaptor (9)
Prozessoren (2)
Softwaregeräte (7)
Speichercontroller (1)
Systemgeräte (25)
Tastaturen (1)
Tragbare Geräte (1)
USB-Controller (12)

The file types are of sorts
.sys
.bin
.dll

The number of sub folders at the next level is approximately 87



Here is an attempt to match them up approximately

 PrintQueue (1) 
DoubleDriver                  Manual from Device Manager Properties

Printer (3)
PrintQueue (1)               Druckwarteshlangen (5)
USB (8)                         USB-Controller (12)    Tragbare Geräte (1)
CDROM (1)                    DVD/CD-ROM-Laufwerke (1)
Computer (1)                 Computer (1)
DiskDrive (1)                 Laufwerk (2)
Display (1)                    Grafikkarten (1)          
HDC (2)                        IDE ATA/ATAPI-Controller (3)
Keyboard (1)                 Tastaturen (1)

System (29)                  Systemgeräte (25)

SoftwareDevice (1)        Softwaregeräte (7)

MEDIA (6)
                                    Audioeingänge und – ausgänge (3)
VolumeSnapshot (1)

Image (1)
Volume (1)
HIDClass (4)                  Eingabegeräte (Human Interface Device) (6)
AudioEndpoint (1)
WSDPrintDevice (1)
WPD (1)
1394 (1)                       IEEE 1394-Hostcontroller (1)
Monitor (2)                    Monitore (1)
Mouse (1)                      Mäuse und andere Zeigegeräte (1)
Net (10)                        Netzwerkadaptor (9)

SCSIAdapter (1)            Speichercontroller (1)
Processor (1)                 Prozessoren (2)