Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi window Excel
This works for both XP and Vista so far
create a notepad doc with the following content between the lines and save as excel.bat ______________________ @echo off cls echo Set File types to Allow Multiple Excel windows echo Make sure Excel is closed before you continue pause reg export “HKCR\Excel.Sheet.8\shell\Open” “%~dp0\Excel8_Open.reg” reg export “HKCR\Excel.Sheet.12\shell\Open” “%~dp0\Excel12_Open.reg” reg delete “HKCR\Excel.Sheet.8\shell\Open\ddeexec” reg delete “HKCR\Excel.Sheet.12\shell\Open\ddeexec” reg import “%cd%\excel.reg” ________________________________________ then create another file in notepad called excel.reg with this content that is between the lines: ______________________________________ Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\comman d] @=”\”C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\” /e \”%1\”" [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command] @=”\”C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE\” /e \”%1\”" ______________________________ keep them in the same directory and run the excel.bat file. From vista you have to open “cmd” as administrator and run it from the command line Enjoy, Britt EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to parse a multi-colum multi-select listbox | Excel Programming | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions | |||
How do I undo the Excel, Window Menu, New Window command | Excel Discussion (Misc queries) | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |