[REQ]-Script to change some Excel's registry entries

Discussion in 'Scripting' started by Mr.X, Apr 27, 2016.

  1. Mr.X

    Mr.X MDL Guru

    Joined:
    Jul 14, 2013
    Messages:
    7,625
    Likes Received:
    14,952
    Trophy Points:
    240
    #1 Mr.X, Apr 27, 2016
    Last edited: Apr 27, 2016
    I need a change script to change some registry entries for M$ Excel program (solely 2010, 2013 and 2016), to make it work along with Sandboxie.
    I can't do a fixed reg file since it has some variables that changes and become unique on every installation on every different scenario.


    Requirements:
    1. The script needs to make a backup (reg file) of the following entries as a first function (here don't matter Office version or achitecture):
    HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open
    HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open
    HKEY_CLASSES_ROOT\Excel.SheetMacroEnabled.12\shell\Open


    2. Then, the script must be able to make the following changes depicted in the image:

    [​IMG]​


    The image shows only Excel.Sheet.8 entry yet the script must consider Excel.Sheet.12 and Excel.SheetMacroEnabled.12 as well.




    To all the scriptmasters in here, thanks in advance for you help :D
     
  2. Mr.X

    Mr.X MDL Guru

    Joined:
    Jul 14, 2013
    Messages:
    7,625
    Likes Received:
    14,952
    Trophy Points:
    240
    #2 Mr.X, Apr 27, 2016 (OP)
    It's interesting how this entry looks in a reg file:

    Original
    [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
    @=""C:\\Program Files (x86)\\Microsoft Office\\Office16\\EXCEL.EXE" /dde"
    "command"=hex(7):7a,00,6e,00,3d,00,42,00,56,00,35,00,21,00,21,00,21,00,21,00,\
    21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\
    00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,3f,00,25,00,38,00,47,00,\
    69,00,63,00,4b,00,63,00,76,00,39,00,6f,00,49,00,60,00,6b,00,77,00,24,00,3d,\
    00,5b,00,55,00,5b,00,20,00,2f,00,64,00,64,00,65,00,00,00,00,00


    Changed
    [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
    @=""C:\\Program Files (x86)\\Microsoft Office\\Office16\\EXCEL.EXE" \"%1""
    "command"=hex(7):7a,00,6e,00,3d,00,42,00,56,00,35,00,21,00,21,00,21,00,21,00,\
    21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\
    00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,3f,00,25,00,38,00,47,00,\
    69,00,63,00,4b,00,63,00,76,00,39,00,6f,00,49,00,60,00,6b,00,77,00,24,00,3d,\
    00,5b,00,55,00,5b,00,20,00,22,00,25,00,31,00,22,00,00,00,00,00

    However, on VMs I watch those hex numbers in blue to vary from installation to installation.
     
  3. KNARZ

    KNARZ MDL Addicted

    Joined:
    Oct 9, 2012
    Messages:
    896
    Likes Received:
    475
    Trophy Points:
    30
    #3 KNARZ, Apr 27, 2016
    You need it for commercial or privat use?
     
  4. Mr.X

    Mr.X MDL Guru

    Joined:
    Jul 14, 2013
    Messages:
    7,625
    Likes Received:
    14,952
    Trophy Points:
    240
    #4 Mr.X, Apr 27, 2016 (OP)
    For private use. Personal computers of my brother, son, wife and mine use Sandboxie and different Office versions.
     
  5. KNARZ

    KNARZ MDL Addicted

    Joined:
    Oct 9, 2012
    Messages:
    896
    Likes Received:
    475
    Trophy Points:
    30
    #5 KNARZ, Apr 27, 2016
    Hmmmmmmm....
    I can do it but it will cost me ca. half to an hour.
    Maybe I find time the next days. - but no promise or commitment.