Loop Through Files In A Folder Using VBA

[DocAElstein]

Here, again, for the mainly DVD instillation are the main added files for this computer ( PoohFirstPetraRotWin7Starter ( Aug 2021 nach repair in PC Shop ) )
At F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\ After Disc Install\drivers I have an extra
usbscan.sys

I then go a long way down in DriverStore to find this lot

F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\ After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j 410.inf_x86_neutral_f8801e0bb3ab9eb4				hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0b b3ab9eb4
				HPScanMiniDrv_DJ1050_J410.INF
				hpscanminidrv_dj1050_j410.PNF
				HPScanMiniDrv_DJ1050_J410x32.CAT
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\ After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j 410.inf_x86_neutral_f8801e0bb3ab9eb4\drivers					drivers
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\ After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j 410.inf_x86_neutral_f8801e0bb3ab9eb4\drivers\scann er
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\ After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j 410.inf_x86_neutral_f8801e0bb3ab9eb4\drivers\scann er\x32
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\ After Disc Install\DriverStore\FileRepository\hpvpl04.inf_x86_neutra l_4dd0ab13ea43b845				hpvpl04.inf_x86_neutral_4dd0ab13ea43b845
				HPMACRONAMES.gpd
				hpvpl04.cat
				hpvpl04.inf
				hpvpl04.ini
				hpvpl04.PNF
				hp_deskjet_2050_04.gpd
				locale.gpd
				stdnames.gpd
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\ After Disc Install\DriverStore\FileRepository\hpvpl04.inf_x86_neutra l_4dd0ab13ea43b845\i386					i386
					hpfime50.dll
					hpinkcoi8911.dll
					hpinksts8911.dll
					hpinksts8911LM.dll
					hpvpldrv04.dll
					hpvplres04.dll
					hpvplui04.dll
					unidrv.dll
					unidrv.hlp
					unidrvui.dll
					unires.dll

Worksheet: FirstPetraPoohWin7


Here a copy from the Immediate Window

F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4	hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4
				HPScanMiniDrv_DJ1050_J410.INF
				hpscanminidrv_dj1050_j410.PNF
				HPScanMiniDrv_DJ1050_J410x32.CAT
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4\drivers	drivers
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4\drivers\scanner
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4\drivers\scanner\x32
					
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpvpl04.inf_x86_neutral_4dd0ab13ea43b845	hpvpl04.inf_x86_neutral_4dd0ab13ea43b845
				HPMACRONAMES.gpd
				hpvpl04.cat
				hpvpl04.inf
				hpvpl04.ini
				hpvpl04.PNF
				hp_deskjet_2050_04.gpd
				locale.gpd
				stdnames.gpd
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpvpl04.inf_x86_neutral_4dd0ab13ea43b845\i386	i386
					hpfime50.dll
					hpinkcoi8911.dll
					hpinksts8911.dll
					hpinksts8911LM.dll
					hpvpldrv04.dll
					hpvplres04.dll
					hpvplui04.dll
					unidrv.dll
					unidrv.hlp
					unidrvui.dll
					unires.dll

Here a paste from the text file produced

 F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4				hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4	
				HPScanMiniDrv_DJ1050_J410.INF	
				hpscanminidrv_dj1050_j410.PNF	
				HPScanMiniDrv_DJ1050_J410x32.CAT	
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4\drivers					drivers
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4\drivers\scanner					
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpscanminidrv_dj1050_j410.inf_x86_neutral_f8801e0bb3ab9eb4\drivers\scanner\x32					
					
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpvpl04.inf_x86_neutral_4dd0ab13ea43b845				hpvpl04.inf_x86_neutral_4dd0ab13ea43b845	
				HPMACRONAMES.gpd	
				hpvpl04.cat	
				hpvpl04.inf	
				hpvpl04.ini	
				hpvpl04.PNF	
				hp_deskjet_2050_04.gpd	
				locale.gpd	
				stdnames.gpd	
					
F:\DriversDruckerFromPoohFirstPetraRotWin7Starter\After Disc Install\DriverStore\FileRepository\hpvpl04.inf_x86_neutral_4dd0ab13ea43b845\i386					i386
					hpfime50.dll
					hpinkcoi8911.dll
					hpinksts8911.dll
					hpinksts8911LM.dll
					hpvpldrv04.dll
					hpvplres04.dll
					hpvplui04.dll
					unidrv.dll
					unidrv.hlp
					unidrvui.dll
					unires.dll

The screen shot of a view of the text file:

---

The conclusion , probably is that this is easer to see in a Excel file,
and
that if we want to view in a forum post, the first of the above, ( which is a Rory Archibald Forum Tools table without borders of a small section of the full drivers files), is probably the best we can get

Oh well, the last Transgression Vamp at least confirmed the above conclusion

---

‘wbCodesDriversDruckerFromPoohFirstPetraRotWin7S tarter.xlsm’ https://app.box.com/s/k9hqq3mq7972kcucn428ghcd4gciquhn