Sign in to follow this  
Followers 0
souldjer777

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

1 post in this topic

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. :huh2:

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")

"Maybe I'm on a road that ain't been paved yet. And maybe I see a sign that ain't been made yet"
Song Title: I guess you could say
Artist: Middle Class Rut

Share this post


Link to post
Share on other sites



Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0