Page 35 of 93 FirstFirst ... 2533343536374585 ... LastLast
Results 341 to 350 of 935

Thread: Windows 10 and Office Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 03-20-2018, 04:09 PM #1
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    C
    D
    E
    215
    		 HID-Tastatur
    216
    		 C:\Windows\system32\DRIVERS\kbdclass.sys
    217
    		 C:\Windows\system32\DRIVERS\kbdhid.sys
    218
    Worksheet: DeviceManagerProperties




    in de-DE

    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    D
    36
    		 IPMIDRV.sys.mui
    37
    		 isapnp.sys.mui
    38
    		 kbdclass.sys.mui
    39
    		 kbdhid.sys.mui
    40
    		 luafv.sys.mui
    41
    		 Microsoft.Bluetooth.AvrcpTransport.sys.mui
    Worksheet: drivers
    Last edited by DocAElstein; 03-12-2020 at 04:45 PM.
    Reply With Quote Reply With Quote
  2. 03-20-2018, 04:09 PM #2
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10

    My China Stick

    My China stick


    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    C
    D
    E
    F
    219
    		 USB_China2
    220
    		 C:\Windows\system32\DRIVERS\UMDF\WpdFs.dll
    221
    		 C:\Windows\system32\drivers\WpdUpFltr.sys
    222
    		 C:\Windows\system32\DRIVERS\WUDFRd.sys
    223
    Worksheet: DeviceManagerProperties




    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    B
    C
    D
    123
    		 G:\Win 10 Devices\Before\drivers\en-US en-US
    124
    		 fwpkclnt.sys.mui
    125
    		 hvservice.sys.mui
    126
    		 ipnat.sys.mui
    127
    		 ks.sys.mui
    128
    		 mshidkmdf.sys.mui
    129
    		 RNDISMP.sys.mui
    130
    		 scsiport.sys.mui
    131
    		 sercx.sys.mui
    132
    		 sercx2.sys.mui
    133
    		 spbcx.sys.mui
    134
    		 ucx01000.sys.mui
    135
    		 WpdUpFltr.sys.mui
    136
    137
    		 G:\Win 10 Devices\Before\drivers\etc etc
    138
    		 hosts
    139
    		 lmhosts.sam
    140
    		 networks
    141
    		 protocol
    142
    		 services
    143
    144
    		 G:\Win 10 Devices\Before\drivers\UMDF UMDF
    145
    		 EhStorPwdDrv.dll
    146
    		 IddCx.dll
    147
    		 Microsoft.Bluetooth.Profiles.HidOverGatt.dll
    148
    		 NfcCx.dll
    149
    		 PosCx.dll
    150
    		 SDFLauncher.dll
    151
    		 SensorsCx.dll
    152
    		 SMCCx.dll
    153
    		 UcmCx.dll
    154
    		 uiccspb.dll
    155
    		 usbdr.dll
    156
    		 UsbXhciCompanion.dll
    157
    		 WpdFs.dll
    158
    Worksheet: drivers
    Last edited by DocAElstein; 03-12-2020 at 04:48 PM.
    Reply With Quote Reply With Quote
  3. 03-20-2018, 04:09 PM #3
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    C
    D
    E
    224
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CB
    225
    		 C:\Windows\system32\drivers\usbhub.sys
    226
    		 C:\Windows\system32\drivers\usbport.sys
    227
    		 C:\Windows\system32\drivers\usbuhci.sys
    228
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27C9
    229
    		 C:\Windows\system32\drivers\usbhub.sys
    230
    		 C:\Windows\system32\drivers\usbport.sys
    231
    		 C:\Windows\system32\drivers\usbuhci.sys
    232
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CA
    233
    		 C:\Windows\system32\drivers\usbhub.sys
    234
    		 C:\Windows\system32\drivers\usbport.sys
    235
    		 C:\Windows\system32\drivers\usbuhci.sys
    236
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27C8
    237
    		 C:\Windows\system32\drivers\usbhub.sys
    238
    		 C:\Windows\system32\drivers\usbport.sys
    239
    		 C:\Windows\system32\drivers\usbuhci.sys
    240
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CC
    241
    		 C:\Windows\system32\drivers\usbehci.sys
    242
    		 C:\Windows\system32\drivers\usbhub.sys
    243
    		 C:\Windows\system32\drivers\usbport.sys
    244
    		 USB-Massenspeichergeräte
    245
    		 C:\Windows\system32\drivers\USBSTOR.SYS
    246
    		 USB-Root-Hub
    247
    		 C:\Windows\system32\drivers\usbd.sys
    248
    		 C:\Windows\system32\drivers\usbhub.sys
    249
    		 USB-Root-Hub
    250
    		 C:\Windows\system32\drivers\usbd.sys
    251
    		 C:\Windows\system32\drivers\usbhub.sys
    252
    		 USB-Root-Hub
    253
    		 C:\Windows\system32\drivers\usbd.sys
    254
    		 C:\Windows\system32\drivers\usbhub.sys
    255
    		 USB-Root-Hub
    256
    		 C:\Windows\system32\drivers\usbd.sys
    257
    		 C:\Windows\system32\drivers\usbhub.sys
    258
    		 USB-Root-Hub
    259
    		 C:\Windows\system32\drivers\usbd.sys
    260
    		 C:\Windows\system32\drivers\usbhub.sys
    261
    		 USB-Verbundgeräte
    262
    		 C:\Windows\system32\drivers\usbccgp.sys
    Worksheet: DeviceManagerProperties




    in de-DE

    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    D
    96
    		 usbehci.sys.mui
    97
    		 usbhub.sys.mui
    98
    		 USBHUB3.SYS.mui
    99
    		 usbport.sys.mui
    100
    		 usbstor.sys.mui
    101
    		 usbvideo.sys.mui
    102
    		 USBXHCI.SYS.mui
    Worksheet: drivers
    Last edited by DocAElstein; 03-12-2020 at 04:51 PM.
    Reply With Quote Reply With Quote
  4. 03-20-2018, 04:09 PM #4
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    C
    D
    E
    240
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CC
    241
    		 C:\Windows\system32\drivers\usbehci.sys
    242
    		 C:\Windows\system32\drivers\usbhub.sys
    243
    		 C:\Windows\system32\drivers\usbport.sys
    Worksheet: DeviceManagerProperties




    in de-DE

    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    D
    94
    		 tunnel.sys.mui
    95
    		 UmBus.sys.mui
    96
    		 usbehci.sys.mui
    97
    		 usbhub.sys.mui
    98
    		 USBHUB3.SYS.mui
    Worksheet: drivers
    Last edited by DocAElstein; 03-12-2020 at 04:54 PM.
    Reply With Quote Reply With Quote
  5. 03-20-2018, 04:09 PM #5
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    C
    D
    E
    244
    		 USB-Massenspeichergeräte
    245
    		 C:\Windows\system32\drivers\USBSTOR.SYS
    Worksheet: DeviceManagerProperties




    in de-DE

    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    D
    98
    		 USBHUB3.SYS.mui
    99
    		 usbport.sys.mui
    100
    		 usbstor.sys.mui
    101
    		 usbvideo.sys.mui
    102
    		 USBXHCI.SYS.mui
    Worksheet: drivers
    Last edited by DocAElstein; 03-12-2020 at 04:55 PM.
    Reply With Quote Reply With Quote
  6. 03-20-2018, 04:09 PM #6
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    usbd.sys is not in drivers


    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    C
    D
    E
    246
    		 USB-Root-Hub
    247
    		 C:\Windows\system32\drivers\usbd.sys
    248
    		 C:\Windows\system32\drivers\usbhub.sys
    Worksheet: DeviceManagerProperties
    Last edited by DocAElstein; 03-12-2020 at 04:56 PM.
    Reply With Quote Reply With Quote
  7. 03-20-2018, 04:09 PM #7
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    not in drivers

    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    C
    D
    E
    261
    		 USB-Verbundgeräte
    262
    		 C:\Windows\system32\drivers\usbccgp.sys
    Worksheet: DeviceManagerProperties
    Last edited by DocAElstein; 03-12-2020 at 04:57 PM.
    Reply With Quote Reply With Quote
  8. 03-20-2018, 04:09 PM #8
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    USB Summary

    _____ Workbook: ExplorerBefore DeviceManager V drivers2.xlsm ( Using Excel 2007 32 bit )
    Row\Col
    C
    D
    E
    F
    219
    		 USB_China2
    220
    		 C:\Windows\system32\DRIVERS\UMDF\WpdFs.dll
    221
    		 C:\Windows\system32\drivers\WpdUpFltr.sys
    222
    		 C:\Windows\system32\DRIVERS\WUDFRd.sys
    223
    224
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CB
    225
    		 C:\Windows\system32\drivers\usbhub.sys
    226
    		 C:\Windows\system32\drivers\usbport.sys
    227
    		 C:\Windows\system32\drivers\usbuhci.sys
    228
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27C9
    229
    		 C:\Windows\system32\drivers\usbhub.sys
    230
    		 C:\Windows\system32\drivers\usbport.sys
    231
    		 C:\Windows\system32\drivers\usbuhci.sys
    232
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CA
    233
    		 C:\Windows\system32\drivers\usbhub.sys
    234
    		 C:\Windows\system32\drivers\usbport.sys
    235
    		 C:\Windows\system32\drivers\usbuhci.sys
    236
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27C8
    237
    		 C:\Windows\system32\drivers\usbhub.sys
    238
    		 C:\Windows\system32\drivers\usbport.sys
    239
    		 C:\Windows\system32\drivers\usbuhci.sys
    240
    		 Intel(R) 82801G (ICH7-Familie) USB universeller Hostconroller - 27CC
    241
    		 C:\Windows\system32\drivers\usbehci.sys
    242
    		 C:\Windows\system32\drivers\usbhub.sys
    243
    		 C:\Windows\system32\drivers\usbport.sys
    244
    		 USB-Massenspeichergeräte
    245
    		 C:\Windows\system32\drivers\USBSTOR.SYS
    246
    		 USB-Root-Hub
    247
    		 C:\Windows\system32\drivers\usbd.sys
    248
    		 C:\Windows\system32\drivers\usbhub.sys
    249
    		 USB-Root-Hub
    250
    		 C:\Windows\system32\drivers\usbd.sys
    251
    		 C:\Windows\system32\drivers\usbhub.sys
    252
    		 USB-Root-Hub
    253
    		 C:\Windows\system32\drivers\usbd.sys
    254
    		 C:\Windows\system32\drivers\usbhub.sys
    255
    		 USB-Root-Hub
    256
    		 C:\Windows\system32\drivers\usbd.sys
    257
    		 C:\Windows\system32\drivers\usbhub.sys
    258
    		 USB-Root-Hub
    259
    		 C:\Windows\system32\drivers\usbd.sys
    260
    		 C:\Windows\system32\drivers\usbhub.sys
    261
    		 USB-Verbundgeräte
    262
    		 C:\Windows\system32\drivers\usbccgp.sys
    263
    264
    Worksheet: DeviceManagerProperties
    Last edited by DocAElstein; 03-12-2020 at 04:58 PM.
    Reply With Quote Reply With Quote
  9. 03-20-2018, 04:09 PM #9
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10



    General notes…attempting to summarise



    The files found by the cmd prompt way are very small in number compared to any other way , and appear to be almost all the files found by any way for the graphic card, (Intel(R) G41 Express Chipset (Microsoft Corporation - WDDM 1.1) ). These are types dll , bin , vp and just one bin and one cpa
    That is approximately 20 files out of approximately 60 files in total for the cmd prompt way. The remaining 40 or so files are not to be found in the list from the Device Manager Properties . They are of the type
    sys 1
    dll 7
    bin 2
    bag 1
    xml 11
    js 3
    gdl 1
    cab 1
    ini 3
    cat 4
    inf 4
    pnf 4
    gpd 3
    exe 1
    Only the graphic card info was in the list from the Device Manager Properties

    For the Double Driver List we see in addition files belonging to
    HP OfficeJet Pro 8720 PCL-3
    HP OfficeJet Pro 8720 PCL-3\amd64
    So some more types were found. These are types are one of a sys, cpa , bag , gdl , cab, exe and a few dll, bin , vp , xml , js , cat, g pd
    The remaining files not to be found in the Double Driver are
    dll 1
    xml 3
    js 1
    ini 2
    cat 2
    inf 4
    pnf 4
    gpd 1

    So the list from Command Prompt things seems to contain very little.

    So I did do a quick check of cmd against drivers and DriverStore
    Nothing at all was found in drivers. The entire files were found in DriverStore grouped in a very similar way..
    _._________________
    From Device Manager Properties we have 120 files, with 5 different types
    sys 95
    dll 13
    bin 6
    cpa 1
    vp 5
    Total 120
    From DoubleDriver
    The full list from Double Drivers looks like this
    sys 128
    dll 49
    bin 3
    cpa 1
    vp 5
    els 1
    inf 81
    ini 107
    cat 4
    gpd 29
    xml 27
    gdl 2
    js 3
    dpd 0
    cab 1
    bag 1
    ppd 1
    exe 1
    dpb 4
    Total 448

    Here we look at the files from Device Manager ( that are in Double Driver )
    sys 95 (70)
    dll 13 (11)
    bin 6 (2)
    cpa 1 (1)
    vp 5 (5)
    Totals 120
    Most of the missing files sys are for “WAN Miniport”
    ExplorerBefore DeviceManager V DoubleDriver2.xlsm : https://app.box.com/s/mrea4z64s63wxs7rsx2j7s8pjypvin35

    Looking back at Double Driver we can list the extra files that it has compared with Device Manager
    sys 78
    dll 38
    bin 1
    inf 81
    ini 107
    cat 4
    gpd 29
    xml 27
    gdl 2
    js 3
    cab 1
    bag 1
    ppd 1
    exe 1
    dpb 4

    Making comparisons to the large Folders, drivers and DriverStore..
    I fear I may have been a bit of a twat initially as I have matched a lot of things in de-DE, and not checked to see if they are also further down.
    These were the results:
    Device manager in drivers
    sys 95 (46)
    dll 13 (1)
    bin 6 (0)
    cpa 1 (0)
    vp 5 (0)
    We should note that almost all paths found from the Device Manage Properties ( apart from a few audio and most of the graphic files) show a drivers in the path. Never the less not all are there.
    Lets see how it changes by doing it right with the find next… it should not, since a find next analysis will just give an extra possibly – and actually we find that all ( but my china USB ) are indeed in the de-DE Folder, and they need to be matched to an extra .mui

    Time to do a find next on the DriverStore:
    In this case, all the files in the dn-DE or en-EN folders have the extension inf_loc So we would not expect to find any files from Device manager there. Duplicates in Driver store, were mostly seen manually, but just to be sure we start again with this macro, ( which did the italicising for the match in place of the colouring which is maintained for the match to drivers , and an underline if the cell was already coloured / matched to drivers ), http://www.excelfox.com/forum/showth...ll=1#post12409 , and add the next bit, then start again
    Thus was the conclusion before were OK, but I will add the find next an repeat it. So I modify this macro first
    http://www.excelfox.com/forum/showth...ll=1#post12409
    Last edited by DocAElstein; 03-12-2020 at 10:04 PM.
    Reply With Quote Reply With Quote
  10. 03-20-2018, 04:09 PM #10
    DocAElstein
    DocAElstein is online now
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10





    So I modify this macro first
    http://www.excelfox.com/forum/showth...ll=1#post12409

    I am only interested in doing a find next in the DriverStore worksheet, ( and I am not expecting it to find many ) . But re selecting and re italicising does no harm and helps slow down and help me see what is going on…

    These are the important code line additions

    Code:
                  Do While Not FndCel Is Nothing ' Start Find next loop ======


              Set FndCel = Application.Range("=DriverStore!D" & FndCel.Row + 1 & ":DriverStore!F4437").Find(what:=FileNmeSrchFor, After:=Application.Range("=DriverStore!F4437"), LookIn:=xlValues, LookAt:=xlPart, searchorder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)  '
              Loop  '  End Find next loop =================================
    .Range("=DriverStore!D" & FndCel.Row + 1 & ":DriverStore!F4437").Find(what:=FileNmeSrchFor, After:=Application.Range("=DriverStore!F4437"), LookIn:=xlValues, LookAt:=xlPart, searchorder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)


    Giving:

    Code:
                  Do While Not FndCel Is Nothing ' Start Find next loop ======
              '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 ' This worksheet will be colured
                Application.Wait (Now + TimeValue("00:00:01"))
                '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.Italic = True
                
                WsDrSt.Activate: FndCel.Select ' the other workseet
                Application.Wait (Now + TimeValue("00:00:02"))
                Let FndCel.Font.ColorIndex = ClrIdx
              Set FndCel = Application.Range("=DriverStore!D" & FndCel.Row + 1 & ":DriverStore!F4437").Find(what:=FileNmeSrchFor, After:=Application.Range("=DriverStore!F4437"), LookIn:=xlValues, LookAt:=xlPart, searchorder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)  '
              Loop  '  End Find next loop =================================
            Else ' No match was found - the thing in the cell in this worksheet is not in the other worksheet

    And finally
    http://www.excelfox.com/forum/showth...ll=1#post12810







    The usual results for matched files are presented in the next posts


    ExplorerBefore DeviceManager V DriverStore2.xlsm : https://app.box.com/s/xokdiupd311mtvzwcsazh15ou13nolnq
    Last edited by DocAElstein; 03-12-2020 at 11:11 PM.
    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. Excel VBA Folder File Search
    By DocAElstein in forum Test Area
    Replies: 39
    Last Post: 03-20-2018, 04:09 PM
  4. 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