[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

    Jul 14, 2013
    8,575
    15,646
    270
    #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

    Jul 14, 2013
    8,575
    15,646
    270
    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

    Oct 9, 2012
    895
    482
    30
    You need it for commercial or privat use?
     
  4. Mr.X

    Mr.X MDL Guru

    Jul 14, 2013
    8,575
    15,646
    270
    For private use. Personal computers of my brother, son, wife and mine use Sandboxie and different Office versions.
     
  5. KNARZ

    KNARZ MDL Addicted

    Oct 9, 2012
    895
    482
    30
    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.