Results 1 to 10 of 100

Thread: Loop Through Files In A Folder Using VBA

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,456
    Rep Power
    10
    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
    Code:
    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
    Code:
     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
    Last edited by DocAElstein; 04-28-2022 at 02:52 PM.

Similar Threads

  1. Replies: 15
    Last Post: 08-23-2013, 12:03 PM
  2. Loop Through And Delete Multiple File Types In A Folder
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 03-30-2013, 04:47 PM
  3. Replies: 2
    Last Post: 03-12-2013, 02:57 PM
  4. Loop through a folder and find word
    By k0st4din in forum Excel Help
    Replies: 7
    Last Post: 12-08-2012, 02:22 PM
  5. Count Files In A Folder VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 05-07-2011, 10:57 PM

Posting Permissions

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