Excel 2007 - Opens sheets in seperate windows - AutoIt registry settings

[souldjer777]

It was driving our users crazy to not have Excel 2007 open different sheets in different windows.

So, I gave them the fix in a compiled AutoIt Exe - because AutoIt freaking rules!

BTW - this will open both xls and xlsx in Office 2007 separate windows.

Excel 2007 - Opens sheets in separate windows - AutoIt registry settings

This applies to office 2007 installed to the default location on the C: drive.

; This will open xls files in office 12 excel in separate windows
    ;[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
    ;@="\"C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" \"%1\""

    
    RegWrite ( "HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command" ,"" , "REG_SZ" ,'"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" "%1"' )

    ; This will open xlsx files in office 12 excel in separate windows
    ;[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command]
    ;@="\"C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\" \"%1\""

    RegWrite ( "HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command" ,"" , "REG_SZ" ,'"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" "%1"' )

    ; This will delete the ddeexec reg folder and forces command for xls

    RegDelete ( "HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec")

    ; This will delete the ddeexec reg folder and forces command for xlsx

    RegDelete ( "HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec")

    ; This deletes any other commands in open that shouldn't be there v8

    RegDelete ( "HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command", "command")

    ; This deletes any other commands in open that shouldn't be there v12

    RegDelete ( "HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command", "command")