Results 1 to 10 of 935

Thread: Windows 10 and Office Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10

    Conclusions/ Summary
    Files from Command windows compared to Device Manager Properties

    We modify the macro from here,
    http://www.excelfox.com/forum/showth...ll=1#post12347 ,
    , to this
    http://www.excelfox.com/forum/showth...ll=1#post12349
    , and then re run on the worksheet with the now coloured found files. The modification is
    _ a) changing from a VBA “array” type code to a “spreadsheet” type code, which in turn allows us to
    _ b) check for cell text colouring, and so allow noting the number of files in any type which were also to be found in the list made from the Device Manager Properties
    We then have the following in the Immediate Window, on running Private Sub FileTypesHereArrays()
    sys 1 (1)
    dll 15 (8)
    bin 3 (1)
    cpa 1 (1)
    vp 5 (5)
    els 4
    bag 1 (0)
    xml 11 (0)
    js 3 (0)
    gdl 1 (0)
    cab 1 (0)
    ini 3 (0)
    cat 4 (0)
    inf 4 (0)
    pnf 4 (0)
    gpd 3 (0)
    exe 1 (0)

    In total only 16 files of the 61 in the list from Command prompt are in the list obtained from the Device manager properties. These are all to do with the Grafikkarten. They comprise 16 of the 21 files from the list obtained from the Device manager Grafikkarten properties

    _____ Workbook: ExplorerBefore cmd V DeviceManager.xlsm ( Using Excel 2007 32 bit )
    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.dll
    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
    Worksheet: DeviceManagerProperties




    Last edited by DocAElstein; 02-19-2020 at 01:09 AM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    KILL A MODERATOR!!

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. Replies: 2
    Last Post: 12-04-2012, 02:05 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
  •